SQL literal string


I have a Column called REASON in my SELECT statement for which i have to attach a literal string that the domain will be 'WC','DB' or 'Wages'.



To be specific



The REASON column should display either 'WC' or 'DB' if not both it should display 'Wages'.



This sounds like a case expression:






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Popular posts from this blog

The Dalles, Oregon

“Thánh nhọ” Lee Kwang Soo chúc thi tốt, sĩ tử Việt Nam... có dám nhận hay không?

眉山市