ok i thought Unicode is just chars 1 to 255, but as i started pushing the limits of my example below, I get all sorts of unique chinese characters.

is...

ahh but you are missing the joins to the INSERTED table;

Every UPDATE in that trigger updates every row in the table with the current value calculated...NOT just for the row...

wow there is so much wrong witht he trigger, i don't know where to start.

it's not designed for more than a single row, so that's one.

every update updates the entire...

i doubt this helps much, but it was fun to look at;

i hate nested OR's and parenthesusi, i get dizzy trying to look through them.

can you compare this query to...

ok the more i look at this the more i get a glimmer of udnerstanding;

i think in that table two columsn represent theDate and TheTime.

CHDE = 1110627 --the date: 2011...

something else that struck me:

(A.CHDE > 1110627 AND A.CHDE < 1110628)

-- this is a Julian-ish date, century 111 month 06 day 27

--isn't that exactly the so someDatefield =1110627 instead?

(A.CHDE...

i had ideas like sturner to fiddle with, but i have no idea whether db2 supports some of the things i'd try.

for example, isntead of selecting the entire tables aliased...

What did you try?

did you try right clicking on SQL S3erver Managment Studio, selecting "run...

it depends on the encryption algorythm;

many encrypt to varbinary, but some others can encrypt to varchar/nvarchar for the encrypted values (AES =varchar, for example),

SQL's built in...

what does not working mean?

you are showing something from excel that you pasted...that doesn't have anything to do with SQL errors or not working as expected or anything., though...

help us...

TOP 1 isn't useful without an ORDER BY.

if you run this:

SELECT * FROM table

where psp_item_no = 'DRR07DFAB0034'

AND psp_ps_no = 16

how many rows show up? if there is more...

nested replaces is the way to do it...same as you started:

replace(replace (xxx,"'","^") ,"""","^")

if you have physical access to the server(laptop?), the first thing to do is right click SSMS...run as...administrator and see if that gets you in.

after that, you might need to...

a trigger runs with every update of course, but the action that it does inside might be limited based on some logic.

also you've got to consider multiple rows in a...

try like this:

insert into ##tmp (ColumnListMatchingsp_dependsOutput)

EXEC (@sql)

if you identify the specific columns, you can have more columns in the table than the proc would insert.