asranantha (8/26/2012)
hi friends i have a small doubt in sql plz solvei have a table that table contains some nullt values and some spaces.
how to seperate what ever contains null values colums and space values columns in sql table
and iam try this output like
select * from tablename where id is null or name is null or sal is null
select * from tablename where id=' ' or name =' ' or sal = ' '
but i want executste this output in one query .flexibls output.
plz tell me that query
pls post the ddl ;
as , for an Int or float , while inserting emptly data , sql server implicitly convert it to 0 , also in the where clause search
select * from tablename where id=' '
select * from tablename where sal = ' '
-- is actually
select * from tablename where id=0
select * from tablename where sal = 0
so first , you better handle data before entering into table for an int or float column;
for an string, IsNull and Rtrim should do.
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm: