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!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by ushakishore
-
iif condition help
it didnt help . When i pasted it IIf([email] Like '*@*.com', 'y', 'n') its giving parsing errors- ushakishore
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
iif condition help
I want to perform a comparison i want to validate email address, so if the column email has adfa@23 then it should return 'False' if it is like adf@adf.com like a regular url then it should return 'true' In sql u can compare like [ where email like '%@%.com') how do you right that in...- ushakishore
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
