I'm sorry, would you like me to come to your office and do it for you?

Yes, there can be issues when you apply the service pack, yes, you might have...

I am not an employer. I dislike like Unions because the promote mediocracy. They are more concerned about the number of Union members, not the membership itself. ...

Yes

Would you care to elaborate on this? You did ask for...

And, of course, when doing this you will...

And Gail, its easy to see why you leave Mike to others to answer. I mean, really.

NO. It means you haven't had any service packs or updates applied to your current installation of SQL Server 2005.

I suggest that you look into getting your system updated.

Try this:

(DT_STR,10,1252)[LIC-NO] + "," + (DT_STR,10,1252)[SSN]

And yes, those are double quotes not two single quotes on either side of the comma.

angel41_23 (3/9/2009)

---

hi..........

i have LIC-NO and SSN fields for all the customers in the database 1 and i have to send them to database2...

And you know why? You are one of the top 3 people on SSC, so they figure if anyone knows the answer you are sure to be the one...

If trade_date is a datetime column, then collation is irrelevant, and the character constants will be converted to a datetime value before the comparison.

Okay, you showed us the how you are trying to accomplish your task, but how about showing us what you are trying to accomplish with some sample data, like '123'...

I hate it when someone PM's me with a problem/question/additional info that really should be posted on an open forum thread. I tend to inform those individuals that I...

I always thought that in a clustered environment both nodes needed to be the same? If one node is 64-bit, the second (and additional) node(s) needed to be as...

Okay, I have to ask, what are you trying to accomplish with this trigger?