Search on Partical Value

Last post 12-12-2005 12:11 PM by bslaght. 2 replies.

Page 1 of 1 (3 items)
	Sort Posts: Previous Next

12-09-2005 11:48 AM

bslaght
Joined on 10-06-2005
Posts 14

Search on Partical Value

Reply Contact

I want to query with a partial name on the database,
I want to search for all of the first names that start with D, seems like unless I put in a match the query won't return results.

12-09-2005 12:30 PM In reply to

Matt Faus
Joined on 08-18-2006
Dallas, Texas
Posts 1,558

Re: Search on Partical Value

Mark as Not Answer Mark as Answer ...

Reply Contact

Try this:

SELECT * FROM customers WHERE CONTAINS(firstName, ' "D*" ')

---------------
Matt Faus

Matt Faus / Microsoft InfoPath MVP
Qdabra® Software / Streamline data gathering to turn process into knowledge

12-12-2005 12:11 PM In reply to

bslaght
Joined on 10-06-2005
Posts 14

Re: Search on Partical Value

Mark as Not Answer Mark as Answer ...

Reply Contact

Thanks I was able to make it work from this.

Page 1 of 1 (3 items)

InfoPath Dev