Skip to Content
Former Member
Oct 19, 2009 at 03:34 PM

If statements in SQL


hi everyone, is it possible to use the equivalent of IF statements in a query?

for example i might want one column in a query to be like:

=IF (t1.creditline < (t1.balance + t1.ordersbal)), "EXCEEDED LIMIT",)

which is saying 'show "EXCEEDED LIMIT" if BP balance plus doctotal is more than creditlimit'

can i do this?