using the LIKE operator

[vickie7408]

I am trying to create a report with account numbers that start with "620". When I entered Like "620*", I am only getting 1 record but I know I have 4 records that should be showing with an account number of "620". Is there another formula I could use?

 

[SkipVought]

Hi,

Are you account numbers NUMERIC data types or TEXT? The LIKE operator works on TEXT.

Skip,

_[red][/red]

 

[SkipVought]

If it's numeric, you may be better off using BETWEEN 62000 and 62099, depending on the length of your Account ID.

Skip,

_[red][/red]

 

[lespaul]

you know Skip, I was going to ask that exact question, but then I tried a like query on a numeric field and it worked. Of course it was not an Access table...but I assumed that the LIKE operator would work to a ISO standard and if it worked on a numeric field in one RDBMS that it would work on an Access table too.

Les

 

[SkipVought]

I guess because the compiler does some kind of a data conversion for you in the background maybe?

Skip,

_[red][/red]

 

[JerryKlmns]

If I remember correctly, the # is the equivelant of ? for one character in numeric fields used with the LIKE operator