Information générale
Catégorie:
Codage, syntaxe et commandes
I did notice you were trimming the "login.user" on the one side and not the other, but Cetin says none of it makes any difference ... so forget what I said.
>>Henry:
>>
>>You're doing a lot of "trimming" in your SQL SELECTs while using the "==" operator ...
>>
>>When using "==" with operands that are of unequal length, you will never get a match ...
>>
>>Conversely, when using the "=" operator, you have to be sensetive to what the SET EXACT setting is.
>>
>Hi Gerry:
>
>Thank you for your kind response. Are you saying that I must SET EXACT OFF?Further, once trimming has taken place, should they not be of equal length? Is this the reason for the unexpected outcome?
>
>Thanks again.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement