Partial field query

N

Nick VL

This has probably been addresed before, but I don't know where to look.
How do I setup the query fields in Infopath so that I can do a query with
only a partial field. Ex. The field is a name, I want to be able to pull up
all the records that contain 'County' in the name. Or say a job ID field, I
want to be able to pull all records containing say 07-3XX where X is unknown.
Right now I have to type in the exact name or number to get a result.
Thanks for any help.
 
S

S.Y.M. Wong-A-Ton

N

Nick VL

How do I create a SQL view? I tried the coding and it kind of worked. I
would like to see how the other option works.

Thanks,
Nick
 
S

S.Y.M. Wong-A-Ton

That's a pretty broad question. Assuming you have a SQL Server installed
somewhere and that you have the SQL Server client tools installed on your PC,
you can use a SQL statement (see
http://msdn2.microsoft.com/en-us/library/aa258253(SQL.80).aspx) to create a
view using SQL Query Analyzer, or you can use the user interface of either
SQL Server Enterprise Manager (SQL Server 2000) or SQL Server Management
Studio (SQL Server 2005) to create a view by running a SQL statement or
designing the view through click actions selecting tables and fields.

If you need help with working with SQL Server, it is best to post your
question in the SQL Server newsgroup.
 
Top