Sql column query

[access101]

im trying to convert code from access to Visual studio dataset query but its not recognizing my LIKE statement

SELECT Staff.Deactivate, Staff.Employee, IIf([Position] Like "*O*","Opener") AS [Open], Staff.Rate1, Staff.Rate2, Staff.Salary, Staff.Availability
FROM Staff
WHERE (((Staff.Deactivate)=False));

 

[dilettante]

What is a "Visual studio dataset query" anyway? And are you saying you have moved from Jet to SQL Server?

 

[SkipVought]

Maybe replace the Immediate If function with a SQL Server compliant Case statement.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[dilettante]

If that's the issue then this thread was posted in the wrong forum. I don't see any VB6 programming question here.