this has been modified using a similar solution given in another post...

DECLARE @text varchar(75)
SET @text = 'this  is   multiple    spaces   reduced...

do you have an id column ?! what is the ddl of the table on which you're setting the trigger ?!

are you not able to grab the modified row using...

I just posted these links yesterday in response to another post - there're a couple of excellent articles on bitwise operators/operations by the "database geek" featured on yesterday's front page...

There is a script on this site that you can modify to do what you want...

Hey Phill - if everyone read BOL then you'd be out of a job...

Eric...here're a link to an article by the "database geek"...

'kay farrell - trying once again - type (all bolded words) exactly in the order given below:

1) start with lesser than sign followed by a - then single space

2) href="http://www.sommarskog.se/dynamic_sql.html"

3)...

Other forums that discuss this issue suggest storing the hyperlink datatypes as varchar in sql server and use the app. to interpret it as hyperlink...here's one such link

yes indeed - this has been noted & discussed before...search site

Best place to start for anything to do with sql server is BOL (books online)...you can go to English Query....Overview....for a beginning..

Here's the definition from that page..

Using English Query, you...

- thought I might learn something about Lotus N...but find instead that the one SSC member - who, until now, has been...

here it is...in BOL..RESTORE DATABASE....and in the Topics found listbox - select the very last one - RESTORE for the syntax details...

I believe it is - "Restore myDB From dbBackup with file = 2"...

I'm sure BOL has something on this...

Ray - just as an fyi - someone else had a similar question once (using t-sql) and I always post lee's solution when I see something like this...

A select * from myTable where (fieldValue like '%VB%Asp%') or (fieldValue like '%ASP%VB%') should get your results - just make sure it works even when the value starts or ends...

...and inspite of all that you're still here to lend a helping hand to others..how commendable is that..