General information
Title:
Creating a Dynamic SQL Statement
Environment versions
Network:
Windows 2000 Server
I have a field which holds a 25 character string. This represents a drawing type code. The first three characters identify the main type, second three class, third three model, etc.
I need a smart SQL statement that will take a parameter of 3 to 25 characters and find matches in my table.
Example Param 1: "0010000000000000000000000" = Seat Assys
would pull all Seat Assys even with other characters set to other than "0"
Or
Example Param 2: "0010010000000000000000000" = Seat Assys,F/C
would pull all F/C Seat Assys
Or
Example Param 3" "0000000010000000000000000" = Model 5300 Seats
would pull all 5300's reguardless of main type or class
Please give me some direction and Thanks.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only