SQL Server Case

[JeremieSimonsen]

Good Afternoon All,

I have the following IIF statement that I need duplicated in SQL. I'm new to SQL so any help will be greatly appreciated.

Field2: IIf(IsNull(live 53_OPCCSMS!CUST _CLASS_CODE),"0 ",LTrim(CStr(li ve53_OPCCSMS!CU ST_CLASS_CODE)) )

[almaz]

[CODE=sql]ISNULL(LTRIM(CU ST_CLASS_CODE), '0')[/CODE]

[Vidhura]

Use case statement
case when IsNull(live53_O PCCSMS!CUST_CLA SS_CODE) then 0 else LTrim(CStr(live 53_OPCCSMS!CUST _CLASS_CODE)) end