Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-26 : 09:57:42
|
| Craig writes "Okay, I give up. I was a good boy and searched your site for an answer to my question. So make all the fun of me you wish, but I will ask my question that surely has a simple answer. SQL Server 7.0 SP3, NT4 SP6a, IIS4, Coldfusion 4.5.1I have a field in my database that has text values separated by a space, a pipe and a space (like | this | example). I need to change the delimiter to a comma with no spaces. I saw information on your site about using a VBScript command similar to this:fieldname = replace (fieldname, "|",",")but I need SQL, not VBScript, if possible. Thank you for your indulgence." |
|
|
|
|
|
Change pipes to commas in field