Hi all, Has anyone come across a solution for faster and powerful search stored procedure in a table that contains more than 500K of records? I am currently trying to work around with it. All helps are appreciated. Thanks. _________________________________________________________________ Express yourself with the latest Windows Live Messenger! Get it free today! http://www.get.live.com/wl/all ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly