SQL syntax question

[WiccaChic]

Are the "where" clauses in the two statements below doing the same thing? If not, anyone know what "where>sortorder,0&quot might do?

select typename, odbctype, precision, lit_prefix, lit_suffix, create_params, nullable, case_sensitive, searchable, unsigned_attribute, money_col, auto_increment
, local_type_name, minimum_scale, maximum_scale, sortorder from sqlnktypes45
where (> sortorder, 0)
order by odbctype, sortorder

select typename, odbctype, precision, lit_prefix, lit_suffix, create_params, nullable, case_sensitive, searchable, unsigned_attribute, money_col, auto_increment
, local_type_name, minimum_scale, maximum_scale, sortorder from sqlnktypes45
where sortorder > 0
order by odbctype, sortorder

 

[olded]

Hi:

In Informix, (> sortorder, 0) is illegal syntax.

Regards,

Ed

 

[WiccaChic]

Thanks Ed,
I was afraid of that. I have a third party application that is choking and I finally managed to catch the process while it was failing and see that it has a SPL thats trying to do this.

Thanks for verifying my fears! I guess the bright side is I can blame whats been a very mysterious problem on a vendor. I am surrounded by MS-SQL guys who just insist on throwing stones at Informix every chance they get!