Home › Building Your Website › Web Database Development

Replace or remove character SQL SERVER

1aspfan posted this at 15:13 — 26th April 2001.

They have: 32 posts

Joined: Jan 2001

Any ideas on how to remove characters from data returned from SQL Server.

Here is the Scenario:

I am returning XML and using XSLT to transform it to Comma seperated values and then open that in Excel. The problem is some of the fields have commas in them. I need to reomve the commas.

Thanks

Mike

Peter J. Boettcher posted this at 18:11 — 26th April 2001.

Peter J. Boettcher's picture

They have: 812 posts

Joined: Feb 2000

You can use the REPLACE function:

SELECT REPLACE(Whatever,","," ") FROM Wherever

I think you can also do this in your XSLT using Translate()

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.