Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SPT Syntax
Message
From
31/10/2011 02:34:27
Steven Dyke
Safran Seats USA
Texas, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SPT Syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP1
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01527658
Message ID:
01527658
Views:
85
I have a field that holds a part number pattern, not the specific part number:

Example: 85786

I need a sql statement that will be given a specific part number and I need to find record matches to the partial part number.

Example:

Select * From myTable Where partialpartnumber(85786) is a part of specificpartnumber(857869-401A).
Next
Reply
Map
View

Click here to load this message in the networking platform