Replacing characters in table

  • Thread starter Thread starter ReidarT
  • Start date Start date
R

ReidarT

How do I by code replace countryspesific characters like "æøå" to a "z" in a
table.
Best regards
ReidarT
 
Hi ReidarT,

I think it should be similar with replacing character 'aaa' to character
'b'; replacing string in the table column/field should be the same. Is
there any specific problem on your side?





Sincerely,

Alick Ye, MCSD
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.




--------------------
| From: "ReidarT" <[email protected]>
| Subject: Replacing characters in table

| How do I by code replace countryspesific characters like "æøå" to a "z"
in a
| table.
| Best regards
| ReidarT
|
|
|
 
How do I by code replace countryspesific characters like "æøå" to a "z" in a
table.
Click to expand...

From A00 onwards there is the Replace function:

UPDATE YourTable SET YourField=Replace(YourField,"å","aa");

HTH - Peter
 
Yes
I want to change all the records in a table by code.
Not the built in find-replace function.
Like
....
vinsøm to vins£m
strædet to str£det
lånet to l£net
....

best regards
ReidarT
 
Hi ReidarT,

The article 210433 provides a sample code which does the exact thing you
are after: replacing specific character in the table

ACC2000: Sample Function to Replace or to Remove Special Characters
http://support.microsoft.com/?id=210433

Please feel free to reply to the threads if you have any concerns.

Sincerely,

Alick Ye, MCSD
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

--------------------
| From: "ReidarT" <[email protected]>
|
| Yes
| I want to change all the records in a table by code.
| Not the built in find-replace function.
| Like
| ...
| vinsøm to vins£m
| strædet to str£det
| lånet to l£net
| ...
|
| best regards
| ReidarT
|
| "Alick [MSFT]" <[email protected]> skrev i melding
| | > Hi ReidarT,
| >
| > I think it should be similar with replacing character 'aaa' to character
| > 'b'; replacing string in the table column/field should be the same. Is
| > there any specific problem on your side?
| >
| >
| >
| >
| >
| > Sincerely,
| >
| > Alick Ye, MCSD
| > Microsoft Online Partner Support
| >
| > Get Secure! - www.microsoft.com/security
| > This posting is provided "as is" with no warranties and confers no
rights.
| >
| >
| >
| >
| > --------------------
| > | From: "ReidarT" <[email protected]>
| > | Subject: Replacing characters in table
| >
| > | How do I by code replace countryspesific characters like "æøå" to a
"z"
| > in a
| > | table.
| > | Best regards
| > | ReidarT
| > |
| > |
| > |
| >
|
|
|
 
Back
Top