Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wildcard character in MS Query
Hi There,
I'm using a parameter for eg [Please enter City] in my MSQuery connecting to my SQL SErver database. How do I allow for an all option. I think it is using a wildcard but can't quite figure it out. Any help greatly appreciated Gordon |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wildcard character in MS Query
If your SQL is set up to use the LIKE operator, the code will accommodate
anything your parameter specifies. Example: WHERE City LIKE [Please enter City] If the parameter equals: Paris Only "Paris" entries will be returned. However, if the parameter is: P* All cities beginning with "P" will be returned. Note: you may need to change the wildcard character to suit your DB. Does that help? Post back if you have more questions. -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) Just an asterisk returns all cities. "Grd" wrote in message ... Hi There, I'm using a parameter for eg [Please enter City] in my MSQuery connecting to my SQL SErver database. How do I allow for an all option. I think it is using a wildcard but can't quite figure it out. Any help greatly appreciated Gordon |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wildcard character in MS Query
Thanks
Will give that a go "Ron Coderre" wrote: If your SQL is set up to use the LIKE operator, the code will accommodate anything your parameter specifies. Example: WHERE City LIKE [Please enter City] If the parameter equals: Paris Only "Paris" entries will be returned. However, if the parameter is: P* All cities beginning with "P" will be returned. Note: you may need to change the wildcard character to suit your DB. Does that help? Post back if you have more questions. -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) Just an asterisk returns all cities. "Grd" wrote in message ... Hi There, I'm using a parameter for eg [Please enter City] in my MSQuery connecting to my SQL SErver database. How do I allow for an all option. I think it is using a wildcard but can't quite figure it out. Any help greatly appreciated Gordon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wildcard character inside sumproduct | Excel Worksheet Functions | |||
Wildcard Character in an Array Formula | Excel Discussion (Misc queries) | |||
How do I use the wildcard character and the NOT function? | Excel Worksheet Functions | |||
Wildcard character | Excel Discussion (Misc queries) | |||
Wildcard Character | Excel Worksheet Functions |