Home › Building Your Website › Web Database Development

REPLACE in SQL Server

1aspfan posted this at 15:35 — 18th May 2001.

They have: 32 posts

Joined: Jan 2001

O.K. Guys

I need to replace all commas in my stored procedure to a single space.

Example

IsNull (SN.shortname, 'Empty ') as 'ShortName'
------------------------------

If SN.shortname contains a comma. I need to remove the comma.

I am using xsl to transform this to .csv and the comma is messing everything up.

Thanks!!

Mike

1aspfan posted this at 19:24 — 18th May 2001.

They have: 32 posts

Joined: Jan 2001

This wokred but I have not yet figured out how to do this with the ISNull. I guess it is a good thing there will never be any nulls in that column.

Replace (SN.shortname, ',' ,'') as ShortName

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.