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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Search Article with the Sequence table

Author  Topic 

matt_calhoon
Posting Yak Master

235 Posts

Posted - 2005-11-16 : 21:11:19
Hi there,

reading Merkins great article here http://www.sqlteam.com/item.asp?ItemID=5857
if the user entered a couple keywords that have inverted commas "" is it possible to keep this as one keyword in the sequence table? i.e.
in the example we have
'my space delimited string'
what if it is
'"my space" delimited string'
I need code that will allow the seuqence table to store as
first row: my space
second row: delimited
third row: string

and not

"my
space"
delmited
string
   

- Advertisement -