Like based on prefix table

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Like based on prefix table

Message

14/05/2013 10:33:41

Gregory Adam
Belgique

14/05/2013 10:24:56

Michel Fournier
Level Extreme Inc.
Petit-Rocher, Nouveau-Brunswick, Canada

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Re: Like based on prefix table

Versions des environnements

SQL Server:

SQL Server 2008

Application:

Web

Divers

Thread ID:

01573772

Message ID:

01573783

Vues:

>>Are you sure your prefix hasn't got a trailing space ?
>
>The LTRIM(), RTRIM() was necessary. As I mention, this is a variable length.

It may be better to store the prefix in a varchar() field

Gregory

Répondre

Fil

Voir

Click here to load this message in the networking platform