The following 2 queries work in Sybase, and also work in MS  SQL:

select * from testDiffTypeSameCol

where IssueNo = 2

and convert(numeric(15,2),StringNumeric) > 1.0

select * from testDiffTypeSameCol

where convert(numeric(15,2),StringNumeric) > 1.0

and IssueNo =...

In Sybase,

this works:

select * from testDiffTypeSameCol

where ( ( IssueNo = 2 and convert(numeric(15,2),StringNumeric) > 1.0 ) or ( IssueNo = 1 and substring(StringNumeric,1, 4) = 'this' ))

February 22, 2025 at 5:24 pm

#4543827

Thank you Moideen1254. Your query is the best and yet simple one. Our query actually is very long and complex. Simply replacing convert with try_convert will get rid of errors.

In...

For:

select * from testDiffTypeSameCol

where ( ( IssueNo = 2 and convert(numeric(15,2),StringNumeric) > 1.0 )  or ( IssueNo = 1 and substring(StringNumeric,1, 4) = 'this' ))

In Sybase it will call "convert(numeric(15,2),StringNumeric)...