RobNotKnowing
MIS
Hi,,,,
I am trying to replace the Nulls with blanks in my query output. Does any1 know how?
I am trying to replace the Nulls with blanks in my query output. Does any1 know how?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Making Nulls Blank
- Thread starter RobNotKnowing
- Start date
- Status
select coalesce(ColumnName,'')
Denis The SQL Menace
SQL blog:
Personal Blog:
Denis The SQL Menace
SQL blog:
Personal Blog:
TysonLPrice
Programmer
Also:
select isnull(Column,'') from table
select isnull(Column,'') from table
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question