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 |
|
Greg.P
Starting Member
1 Post |
 Posted - 2001-05-29 : 20:16:19
|
| I'm developing an ASP page to search a telephone list held as a CSV. This search is case sensitive. The data in the CSV file has been entered with the initial letter of each word in upper case and other letters in lower case. I've written a sub to change all input to this form. The trouble is that my search does not handle input of two words. I've inserted response.write statements in my code to show the conversion process for case. The output from these statements indicate that everything goes to plan e.g. 'hELP mE' becomes 'Help Me', but the search returns my 'No match' message. How can I fix this? My next step is adapt this to search a SQL Server database. Do I need to worry about this problem? |
|
|
|
|
|
Searching a CSV