How is the better technique for do it in SQL Server 2000?

I need a Incremental Search, search any char the user intro for show the person's names match the intro.

In VFP I know how I can do, but the same technique in SQL Server is very hard to do.

Thanks,
José Luis