Hi, How can we implement select statement with following key words like im MS Query :
begins with includes % When I use like and search for example 123456, all records beginning with 123456 are selected. But I want to have them when I append * at the end of the key. So in this case I cannot select only records equal to 123456. So I want to have a query (written with select) and get only records 123456 when I wrote 123456 , and get only records beginning with 123456 when I wrote 123456*. Thanks, Syner ____________________________________________________________________________________Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when. http://tv.yahoo.com/collections/222 [Non-text portions of this message have been removed]