V4RB2 comparison model

[erne]

on 28-03-2005 23:23, Ruslan Zasukhin at sunshine at public.kherson.ua wrote:

>> 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?
> 
> I think no. bug.
> Integer is similar to long.
> 

OK, I'll tell it to Mantis...

>> Moreover I feel the need here of data conversion functions like
>> Str(integer) as String and Val(string) as Real
> 
> 2.0 support SQL's feature type cast.
> 

please explain, how does this work? what syntax?
I've searched the SQL docs but couldn't find anything about this


Cool Runnings,
Erne.
-- 
| e r |  Ernesto Giannotta
| n e |  Musical Box - a media store