last question on SQL string (hopefully)

thanks for your patience all

nearly done on the DB SQL string..


now I need to do once last check...check on an empty field

something like :- select from users where field not empty

which in any normal world might look like

SELECT * FROM users WHERE this_field <> ""

but problems here with inverted commas etc..

I've tried a whole bunch of strings but none seem to work, cos I'm just so
damn thick!!!!

and the solution is...step forward people cleverer (great word) than me....

thanks again


VERY VERY frustrating knowing exactly what you want to do but lacking the
skills to do it

Aaron
Mon Jan 05 13:10:56 CST 2004

WHERE LEN(this_column) > 0

(This will take care of empty strings and NULL values.)

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/




"Alistair" <news@*remove*alistairb.co.uk> wrote in message
news:vvjcn2h75dfe09@corp.supernews.com...
> thanks for your patience all
>
> nearly done on the DB SQL string..
>
>
> now I need to do once last check...check on an empty field
>
> something like :- select from users where field not empty
>
> which in any normal world might look like
>
> SELECT * FROM users WHERE this_field <> ""
>
> but problems here with inverted commas etc..
>
> I've tried a whole bunch of strings but none seem to work, cos I'm just so
> damn thick!!!!
>
> and the solution is...step forward people cleverer (great word) than
me....
>
> thanks again
>
>
> VERY VERY frustrating knowing exactly what you want to do but lacking the
> skills to do it
>
>
>
>