Isnull question

Question

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

SSC Guru

Points: 294069

June 9, 2005 at 11:12 am

Amen .

Russell Shilling SSCarpal Tunnel Points: 4399 More actions · Answer 2

In SQL2K:

select isnull(convert(varchar(10),@X,101),'Unassigned')

So long, and thanks for all the fish,

Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3