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 - 2001-08-01 : 09:57:26
|
| Gary writes "Hi there, I am working on a research project where none of the tables in the database are necessarily related until information is put in. I have to build an interface where the user can type in any phrase, and any matching records between two or more tables will be displayed. The end user is looking for relationships between these seemingly unrelated tables. If anyone has any suggestions or would like to help, I would appreciate it. I am new to a lot of this. I've been reading up on reg expressions, multiple select statements with UNions, and full text searching. I am running SQL Server 2000. Also another quick question? I have multiple textareas on the page where the end user inputs data, because of their preferences. For example there is a text area where multiple first names and lasts are entered seperated by commas. SQL will not insert this data and says it will be truncated. how dso I replace the commas. Thanks for your help." |
|
|
|
|
|
full text searching & select from multiple tables