editing a query

  • Thread starter Thread starter Texas Tonie
  • Start date Start date
T

Texas Tonie

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
 
This is from the Autofilter........maybe someting like it will work for
you...........

Criteria1:="=a*"

Vaya con Dios,
Chuck, CABGx3
 
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)
 
Like '%' + [parameter] + '%' works in SQL..........

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

Criteria1:="=a*"

Vaya con Dios,
Chuck, CABGx3


Texas Tonie said:
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
Click to expand...
Click to expand...
 
It turns out that

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



Ron Coderre said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top