Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Andrzejek on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

converting code

Status
Not open for further replies.

babeo

Technical User
Mar 30, 2000
398
CA
Hello,
Looks like there is not "IQ forum" in here, nor "ASA" either, so I just post my question and if anyone could help me please?
I want to convert the ASE code to IQ sybase code, and there is a case expression that I am stuck with it ! Don't know the syntax, but I get words that IQ syntax will be familiar with ASA code, which I don't know either, Could someone help please? Thanks

ASE code need to be converted to IQ:
"msa_nbr" = case when b.msa_nbr is null or b.msa_nbr = "" then "Unknown" else b.msa_nbr end,

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top