replace

Hi Guys
Stupid question,
How would I replace all euro signs with pound signs within a column in a
database?
would I use SELECT REPLACE?Yes, why not,
SELECT REPLACE('TESTthis','this','here')
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Jaco Wessels" <jaco_wess@.yahoo.co.uk> schrieb im Newsbeitrag
news:%23gHMnuoRFHA.2748@.TK2MSFTNGP09.phx.gbl...
> Hi Guys
> Stupid question,
> How would I replace all euro signs with pound signs within a column in a
> database?
> would I use SELECT REPLACE?
>|||Try this:
replace(fieldname, '?', '$')
I got the symbol from Word.
"Jaco Wessels" <jaco_wess@.yahoo.co.uk> wrote in message
news:%23gHMnuoRFHA.2748@.TK2MSFTNGP09.phx.gbl...
> Hi Guys
> Stupid question,
> How would I replace all euro signs with pound signs within a column in a
> database?
> would I use SELECT REPLACE?
>|||I think this works better for you:
SELECT REPLACE('128?',CHAR(128),CHAR(163))
Jens Suessmeyer.
"Ross Culver" <rculver@.alliant-solutions.com> schrieb im Newsbeitrag
news:OGee72oRFHA.1348@.TK2MSFTNGP15.phx.gbl...
> Try this:
> replace(fieldname, '?', '$')
> I got the symbol from Word.
> "Jaco Wessels" <jaco_wess@.yahoo.co.uk> wrote in message
> news:%23gHMnuoRFHA.2748@.TK2MSFTNGP09.phx.gbl...
>|||Thanks, on closer inspection the user was mistaking a euro sign with oe
ligature (o)
SELECT REPLACE(Instructions,char(156),char(163)
) from Event
GO
Update Event
Set Instructions = REPLACE(Instructions,char(156),char(163)
)
"Ross Culver" <rculver@.alliant-solutions.com> wrote in message
news:OGee72oRFHA.1348@.TK2MSFTNGP15.phx.gbl...
> Try this:
> replace(fieldname, '?', '$')
> I got the symbol from Word.
> "Jaco Wessels" <jaco_wess@.yahoo.co.uk> wrote in message
> news:%23gHMnuoRFHA.2748@.TK2MSFTNGP09.phx.gbl...
>