Information générale
Catégorie:
Codage, syntaxe et commandes
>In comparing a numeric field from a table against a character variable, I get unexpected results. For example...
>x='1234'
>y=1234 (numeric field from the table)
>
>I convert the numeric to character by...
>y=alltrim(str(y))
>
>for continuity sake, I do an alltrim on the character field too...
>x=alltrim(x)
>
>When I then do a compare of x and y, sometimes they're equal and sometimes they're not.
>
>It's probably something really basic that I'm missing, but I'm really puzzled.
>Any help, please?
>Rich Murillo
Potential "gotcha" is when comparing strings for equality using "=" rather than "==" when SET EXACT is OFF
There's also the "gotcha" when you're comparing numeric values for equality when floating point is involved.
Précédent
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