What to use in place of EMPTY(), TRIM(), and ALLTRIM()? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

What to use in place of EMPTY(), TRIM(), and ALLTRIM()?

Message

De

08/03/2008 15:51:00

Sergey Berezniker
New York, États-Unis

À

08/03/2008 15:16:20

Dmitry Litvak
Massachusetts, États-Unis

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Autre

Titre:

Re: What to use in place of EMPTY(), TRIM(), and ALLTRIM()?

Versions des environnements

SQL Server:

SQL Server 2005

Divers

Thread ID:

01300053

Message ID:

01300062

Vues:

10

>>For character fileds you can replace EMPTY with LEN(MYFIELD)=0. LEN() ignores trailing spaces.
>>TRIM() -> RTRIM()
>>ALLTRIM() - LTRIM(RTRIM(...))
>>
>
>Thank you very much!

You're welcome

--sb--

Click here to load this message in the networking platform