var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Cast issue -varchar to int
I am trying to execute a query utilizing CAST but can't seem to see where my syntax is incorrect, any help would be appreciated.
select * from mygtp.registry a, mygtp.tv3_common_message b where (cast(a.MSG_STORE_ID as int) >= cast('1234' as int) and a.ticket_id=b.BUSINESS_TRANSACTION_ID
Check your parenthesis. Also why are you casting a literal?