Hello all, I have a SQL question. In VFP you can use an IIF() statement inside a SELECT statement. What can I do in VB.NET to get the same effect. I have tried using IIF() and it doesn't work. I have tried putting an IF statement inside the SELECT statement, but I keep getting syntax errors. Thanks for the help.