question

gtrman57 avatar image
gtrman57 asked

I have a query which shows users her of the fields do not have data, how can I get them to just show text like 'nodata'

aaaaaaaaaaa=aaaaaaaaaa

sql query
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
ThomasRushton avatar image
ThomasRushton answered

Check the "ISNULL" function.
or the "COALESCE" function.


There's a comparison post here: https://blogs.msdn.microsoft.com/sqltips/2008/06/26/differences-between-isnull-and-coalesce/

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.