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