V4RB2 comparison model

[erne]

Hello Ruslan,

comparing an integer to a string data are coerced as real numbers
but comparing a Long field to a String field data are coerced as strings

e.g.
let's have LongField = 50 and StringField = "50"
Select * from Table Where LongField = StringField
finds nothing
Select * from Table Where Trim(LongField) = StringField
finds the record

is this the intended behaviour?

Moreover I feel the need here of data conversion functions like
Str(integer) as String and Val(string) as Real


Cool Runnings,
Erne.
|er| musical box
|ne| a media store