Posted by feucos on 10/21/06 16:05

Hi all,

I am new to these so plz never mind if this is funny.

here is my problem :

Table : moody

Column : Title

New column : Nospace

I have data in "Title" column of many rows which are normal sentence.

My requirment is to remove the "white space", +, | , ., / , ! @, $, %
etc special characters and fill it by ( hyphen) and put it in new
"Nospace" Column

Example :

I have : Hurray ! I won the Game

Needed : Hurray-I-won-the-Game

Can any body helpme in getting an SQL Query for this if possible

Thanks in Advance

• Next in forum: Re: Need your help to remove spaces in the column entries using SQL
• Prev in forum: Re: Migration from SQL 2000 to 2005
• Thread view: Need your help to remove spaces in the column entries using SQL

[Reply to this message]