i see. Thanks guys.

trust me i'm w/ you. Especially what this is for. Some nickle and dime content managment system being used by 10 people max. Not my call though. The person defining...

odd. i couldnt post the whole thing at once. had to do it in chuncks......very strange

--So this would insert a record w/ the below

--[desc] = UserOne

--[encryptedValue] = UserOneEncrypt

--How can i create a trigger so when the record is inserted or updated the passord...

insert into [dbo].[tbl1]( [desc], [encryptedValue] )

values ( 'UserOne','UserOneEncrypt')

sorry. having trouble getting the rest of my scripts in here....

CREATE TABLE [dbo].[tbl1](

[desc] [nvarchar](100) NOT NULL,

[encryptedValue] [nvarchar](100)...

uniqueIdentifier?

u need top include the unique index 'kp_slownik_kod_idns'. It's whats failing and i dont see it in the code. Uless i'm missing something.

Excellent guys, thanks!!!!

Let me rephase this. Does anyone know where i can get a file that has all the city, state, zips? Preferably a free one? If not does anyone have a...

lol. I see.

thanks guys

MY SOLUTION WAS CLOSE.

WHATS UP W/ THE stuff function u guya are using. Is that to get rid of the trailing comma? How?

neverind i found the solution

select distinct stock

, (select imgname+','

from #test

where stock = tt.stock

order by imgname

for xml path('')

) st

from #test tt

that, my friend, is really cool. This is very useful for anyone optimizing or building search functionality. I plan on doing that at my current work space. My guess is...

So are there any functions in sql server who are SARGable?

left(), reverse()....?