Query problem

W

Will

Hello,

I know how to set up query parameters where the paramater entered
provides a value for one of the query fields. What I am struggling with
is setting up a parameterised query where the parameter entered is the
first character in a field. In other words I want to parameteries a
"begins with" criteria. In the Value field within MS Query I have
entered Like '[parameter]%' which obviously isn't working.

Can anyone tell me the correct syntax please?

Thanks in advance

Will
 
V

vezerid

replace the % with *. Different systems use different wildcard
characters to make life spicier.

HTH
Kostis Vezerides
 
W

Will

No joy with that I am afraid.

For info if I use the query builder the syntax for a 'begins with'
query is

'A%'

I want to bring back different fields based on the starting letter of
that field. By making it parameterised I get round the fact that the
ODBC interface crashes due to the amount of data I am trying to bring
back.

Thanks

Will
 
Top