• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 169
  • Last Modified:

value $ money in sql server 2005

told to change $ to £  in a database

what do i need to do
0
rgb192
Asked:
rgb192
2 Solutions
 
Aneesh RetnakaranDatabase AdministratorCommented:
update tablename
set columnName = replace (ColumName, '$', '?' )
where  charindex('$', columnName) > 0
0
 
pcelbaCommented:
The question is if this is not the character from Windows regional settings used to display money data...

Let say no. Then I would recommend to use Unicode string for update because some character sets do not support £ sign. And the column itself should support Unicode, of course:

update tablename
set columnName = replace (ColumName, '$', N'£' )
where  charindex('$', columnName) > 0

0
 
rgb192Author Commented:
thanks
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now