using wildcards

[SeeBee]

I have a Definition field that I only want certain records for:

WALKUP/12345/LORIANE X1234

The 12345 number will vary, but rest of information will be the same.

Would I use a 'like'? Not sure how I would write it -

{Job History.Ship Via} = "W" and
{Job History.UserDef01} like "WALKUP/?????/LORIANE"

or

{Job History.Ship Via} = "W" and
{Job History.UserDef01} like "WALKUP/?????/LORIANE *"[/color red]

Thanks for your help,
seebee

 

[vidru]

Try:

{Job History.Ship Via} = "W" and
{Job History.UserDef01} like "WALKUP/*/LORIANE*"

-dave

 

[SeeBee]

Sorry, but I entered as you suggested and returned no results. I know there are records, as I've seen a few.

Selection Expert reads like this:

{Job History.Ship Via} = "W" and
{Job History.UserDef01} like "WALKUP/*/LORAINE *"

If I enter only {Job History.Ship Via} = "W" and
{Job History.UserDef01} like "WALKUP/" [/color red] returns 200 records

seebee

 

[vidru]

Can you post your version of Crystal, data source, and method of connectivity?

After trying the method I suggested, go to Database > Show SQL Query, copy the text, and paste it back here.

-dave

 

[SeeBee]

Crystal 7.0 Professional

"Show SQL Server" is grayed out.

seebee

 

[lbass]

Try:

{Job History.Ship Via} = "W" and
{Job History.UserDef01} like "WALKUP/" + "*" + "/LORAINE"

Also, note that you have used inconsistent spellings for "Loraine" (or "Loriane").

-LB

 

[tektipdjango]

Maybe there is a problem with the "/" character which is perhaps an escape char. Check your help for this.

--------------------------------------------------
[highlight]Django[/highlight]
bug exterminator
tips'n tricks addict​

 

[tektipdjango]

Let's have a look at
left({Job History.UserDef01},7)= "WALKUP/" and right({Job History.UserDef01},8)="/LORIANE" and len({Job History.UserDef01}=20

--------------------------------------------------
[highlight]Django[/highlight]
bug exterminator
tips'n tricks addict​

 

[tektipdjango]

Oh I saw in your first post something after the LORIANE word, what is it exactly, are there blank spaces, how many, and have you try to enter in the like statement the entire text EXACTLY

--------------------------------------------------
[highlight]Django[/highlight]
bug exterminator
tips'n tricks addict​