Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Wildcard (LIKE) in IIF 1

Status
Not open for further replies.
Melagan

Melagan

MIS
Nov 24, 2004
443
US
What I'm trying:

Code: 
SELECT IIF([Status] = LIKE 'Cancelled*', 1, 0) as sCount

Not working - is it even possible to use wildcards in the IIF function?


~Melagan
______
"It's never too late to become what you might have been.
 
Sort by date Sort by votes
Remove the equal (=) symbol.
Try again.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
Bingo! Thank you sir!

(See that? A straight answer in two minutes. *)



~Melagan
______
"It's never too late to become what you might have been.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
2K
combo
combo
C
  • Locked
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
321
OzFoxy
OzFoxy
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
621
mikrom
mikrom
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
4K
combo
combo
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
4K
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top