Home Forums SQL Server 2005 Business Intelligence select query modification RE: select query modification
Lowfar
Ten Centuries
Points: 1005
More actions
April 10, 2009 at 3:50 am
#975632
Hi
My mistake I missed some info out of my previous example.
SELECT T1.ADID, T1.COUNTRY, ISNULL(T1.STATE,'the text you want instead of NULL')
FROM yourtable AS T1