Query problem

[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

 

[vezerid]

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

HTH
Kostis Vezerides

 

[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