Hi Friends i am new with regular expression. I need a mysql query which can search string in a particular fiels with following patterns. 1. Search AJ without space 2. Space befor AJ 3. Space After AJ 4. Space between AJ 5. . symbol between AJ Please help me my table name in soldier and field name is initial in which i have to apply sql query. Thanks vivek_asc