Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
STRTRAN equivalent in TSQL
Message
 
To
11/07/2012 12:22:34
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01548194
Message ID:
01548196
Views:
70
This message has been marked as a message which has helped to the initial question of the thread.
>We need to remove some characters like /, - from phone number and fax numbers.
>Is there an equivalent to STRTRAN is TSQL?
>In not, what's the best way to remove them?
>Thanks

Look at the REPLACE function
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform