T-SQL equivalent of StrTran()? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

T-SQL equivalent of StrTran()?

Message

De

01/06/2012 13:19:57

Sergey Berezniker
New York, États-Unis

À

01/06/2012 12:51:51

Dmitry Litvak
Massachusetts, États-Unis

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Autre

Titre:

Re: T-SQL equivalent of StrTran()?

Versions des environnements

SQL Server:

SQL Server 2005

Divers

Thread ID:

01545078

Message ID:

01545084

Vues:

49

>Is there a function in SQL Server that works like STRTRAN in VFP? I have the following line in VFP that I need to convert to T-SQL:
>
>

>cString = STRTRAN( cString, '&' + 'amp;', '&' )
>

>
>Any suggestions on how to do it? TIA.

REPLACE()

--sb--

Click here to load this message in the networking platform