Prev: SELECT Issue
Next: duplicate records
From: Brian Conner via SQLMonster.com on 4 Dec 2009 14:09
I have a Patient Name Field and the names are formated like this: ROCHA, TAMI

There is a Space after the Comma that seperates the First and Last Name how
can I remove this space? It should look like this: ROCHA,TAMI

--
Brian Conner

Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/200912/1

From: Russell Fields on 4 Dec 2009 14:16
REPLACE (Patient_Name, ', ' , ',')

Use it in a select for display purposes or in an update to change the data
stored in the column.

RLF

"Brian Conner via SQLMonster.com" <u47161(a)uwe> wrote in message
news:a018f79c7fbcf(a)uwe...
>I have a Patient Name Field and the names are formated like this: ROCHA,
>TAMI
>
> There is a Space after the Comma that seperates the First and Last Name
> how
> can I remove this space? It should look like this: ROCHA,TAMI
>
> --
> Brian Conner
>
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/200912/1
>

From: Brian Conner via SQLMonster.com on 4 Dec 2009 14:38
Worked like a Charm...... Thank you


Russell Fields wrote:
>REPLACE (Patient_Name, ', ' , ',')
>
>Use it in a select for display purposes or in an update to change the data
>stored in the column.
>
>RLF
>
>>I have a Patient Name Field and the names are formated like this: ROCHA,
>>TAMI
>>
>> There is a Space after the Comma that seperates the First and Last Name
>> how
>> can I remove this space? It should look like this: ROCHA,TAMI

--
Brian Conner

Message posted via http://www.sqlmonster.com

 | 
Pages: 1
Prev: SELECT Issue
Next: duplicate records