What data are you accessing? The syntax of the select statement is dependant on the back-end data. If you are using SQL Server then use the CASE statement.

>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.