IF in SQL SELECT statements

[#1]

Hi,

Just new to Qlik. I need to put in some conditional selection in my SQL, such as

SQL SELECT IF(field_a = ' ', field_b, field_a) AS myfield

     FROM mytable

However, no matter how I fiddle with it, the script throws an error. What am I doing wrong?

Steven

[#2]

I think I figuredit out myself. I was working on the assumption that I needed to use Qlik syntax or standard SQL syntax, when in fact it turns out that one uses the native syntax of the database source that is being queried!