Category "qsqlquery"

CASE statement in a temp table to format a decimal value SQL --> Syntax error

I am trying to use a case select for a $ pay field. If the field is 0.00 then i want the decimal formatted as a blank fill of length 10 0's else give me the dec