Is there a way to use Greater then and less then with Like operater?

[smercer]

Hi all

I was wondering if there is a way to use the like operater with the less then "<" and greater then ">" signs
tried using:

If Left([ISBN_Number], 3) Like [#00-#19] Then

but does not work.

Does anyone have any ideas?

Thanks in advance

 

[Adrianna]

Assuming [#00-#19] is a numeric field, you would not use "LIKE". You can simple replace it with the < or > symbol.

If Left([ISBN_Number], 3) > [#00-#19] Then