Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Major problem with indexing
Message
 
 
À
30/09/2008 15:27:39
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01351824
Message ID:
01351896
Vues:
19
>>
>>declare @x char(20)
>>set @x = 'test%'
>>select @x + '<'
>>
>>declare @y varchar(20)
>>set @y = 'test%'
>>select @y + '<'
>>
>>
>>there's a big difference between those two as far as the LIKE operation is concerned
>
>I am not sure I understand your examples here.

These two things are not equivalent as a LIKE clause
test%               <
test%<
The trailing spaces are significant between the char() and the varchar() variables.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform