Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-03 : 08:47:45
|
| Kes writes "I have a table listing all our software details: application_name, serial_number, inhouse_id, date_installed The Inhouse_ID: is compiled by the first 6 letters off the Application name, the initials of the user and the date installed.I need to select the records installed by certain users on certain dates. How can I Select * from Software_Details Where instr(inhouse_id,'UserInitials',1) = 'UserInitials'Thanks IA" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-02-03 : 09:37:53
|
| look up charindex and patindex ... or the LIKE keywordJay White{0} |
 |
|
|
|
|
|
Selecting partial