- This topic has 1 reply, 2 voices, and was last updated 15 years, 7 months ago by
.
Viewing 2 posts - 1 through 2 (of 2 total)
-
Posts
-
Hi
i am a newbie to mysql i am generating birt reports in table. state is one of the fieldname of my table. state contains null values along with that some strings. But i dont want this null values in the table to display in the place of null values i want to give one common string value so i changed the select statement as follows SELECT advid ,country,ISNULL(‘all’,STATE ) FROM T1
but i noticed that whole state values has been changed to string ‘all’ but i want only null values to change.wat can i do reply me
Thanx.
Viewing 2 posts - 1 through 2 (of 2 total)