Hi

sorry i am using mssql not mysql now can u please tell me how to replace a null value with string.

Thanx

Hi

i have tried this ISNULL(state,'all') but it is giving null values as it is wen i tried this ISNULL('all',state ) not only null values whole field values r...

I'm sure i want to eliminate the NULL values within my SELECT i have used this code given by u ISNULL('all',STATE ) it...

sorry i cant get this i dont want to insert or update the table i just want to use select statement.

Thanx.

Thanku krayknot for ur reply.

Hi

i am developing birt reports from mysql database wen i am retriving data from the table SELECT advid , country , state, city

FROM ...

Hi

matt its giving same result i.e., it is giving same null value and in the field name state is replacing with UNNAMED_3 any more information regarding this

...

hi matt thanx for ur reply but its not working iwill give u some idea about my table in my table adid, country, state ,city are the field names but...