editing a query
 

Hello,

I want to add a query criteria using the 'begins with' option.

I cannot get the syntax right. Choosing --- begins with [xxx] ----- does
not work.

what should it be?

Help much appreciated,

A struggling Texas Tonie

editing a query
 

This is from the Autofilter........maybe someting like it will work for
you...........

Criteria1:="=a*"

Vaya con Dios,
Chuck, CABGx3


"Texas Tonie" wrote in message
...
Hello,

I want to add a query criteria using the 'begins with' option.

I cannot get the syntax right. Choosing --- begins with [xxx] -----
does
not work.

what should it be?

Help much appreciated,

A struggling Texas Tonie

editing a query
 

Try something like this:

The below SQL selects names that begin with the letter A.

SELECT myTbl.Name
FROM myTbl
WHERE myTbl.Name LIKE 'A%'

Note: The Pct Symbol (%) is a wildcard

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Texas Tonie" wrote in message
...
Hello,

I want to add a query criteria using the 'begins with' option.

I cannot get the syntax right. Choosing --- begins with [xxx] -----
does
not work.

what should it be?

Help much appreciated,

A struggling Texas Tonie

editing a query
 

Like '%' + [parameter] + '%' works in SQL..........

"CLR" wrote:

This is from the Autofilter........maybe someting like it will work for
you...........

Criteria1:="=a*"

Vaya con Dios,
Chuck, CABGx3


"Texas Tonie" wrote in message
...
Hello,

I want to add a query criteria using the 'begins with' option.

I cannot get the syntax right. Choosing --- begins with [xxx] -----
does
not work.

what should it be?

Help much appreciated,

A struggling Texas Tonie

editing a query
 

It turns out that

Like '%' + [parameter] + '%' works in SQL



"Ron Coderre" wrote:

Try something like this:

The below SQL selects names that begin with the letter A.

SELECT myTbl.Name
FROM myTbl
WHERE myTbl.Name LIKE 'A%'

Note: The Pct Symbol (%) is a wildcard

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Texas Tonie" wrote in message
...
Hello,

I want to add a query criteria using the 'begins with' option.

I cannot get the syntax right. Choosing --- begins with [xxx] -----
does
not work.

what should it be?

Help much appreciated,

A struggling Texas Tonie