Using Like for Strings what is used for

[Margah]

I am using the Like expression for strings what would i use for Numbers.

 

[EBGreen]

Between? Maybe. If you want to do fuzzy matching, you can't AFAIK.

[blue]"Well, once again my friend, we find that science is a two headed beast. One head is nice, it gives us aspirin and other modern conveniences,...but the other head of science is BAD! Oh, beware the other head of science, Arthur; it bites!!" - The Tick[/blue]

 

[Craig0201]

You certainly can use LIKE for numbers with a bit of thought.....

SELECT
WhatEver
FROM
WhereEver
WHERE
CStr(YourNumberField) LIKE "*" & YourCriteria & "*"

All you do is cast your number field to a string using CStr.

Craig