0 eeyc 8 Years Ago Hii I Have Facing with Order problem i try to query From Table it go like this -> SELECT * FROM Client WHERE (ClientName LIKE 'X%') OR (ClientName LIKE '%[ ]X%') It mean give me all clients that start Whit X Letter And Included MiddleName If There is And Last Name. but With Out Ordering!! And i need to Order it!! first by Name after it by MiddleName and by LastName... for example -> ClientName Erorn Mikel Bon Joi Jack clint cary Erorn Mikel Bon Jacov mohamd abo jaml habdalhaa jaber mahmoud ben saber now query all names that Start With 'J'! result need to look like this 1. Jack clint cary 2. jaber mahmoud ben saber 3. mohamd abo jaml habdalhaa 4. Erorn Mikel Bon Jacov 5. Erorn Mikel Bon Joi i don't know how to order it, Someon Have an idea how to start ? eyal.c mssql Edited 8 Years Ago by peter_budo: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.