Re: Empty Set Query question

2001-05-01 Thread Erica B. Tanner
Thanks to all for the suggestions!! Turns out, if I use a regular expression instead of a text compare I get the desired result!! :) Thanks! Erica Gerald Clark wrote: > You are doing a text compare, and they have to match exactly, > including leading zeros after the dots. > > You might look a

Re: Empty Set Query question

2001-05-01 Thread Gerald Clark
You are doing a text compare, and they have to match exactly, including leading zeros after the dots. You might look at storing them as integers. MySQL has to functions INET_ATON() and INET_NTOA() to convert them back and forth to strings. Erica B. Tanner wrote: > Hello everyone. I am new to t