DSXchange

So... resolved?

OK.

Use Convert() to remove them by converting them to "". Use the CHAR() function to represent the "weird" character(s) you want to remove.

Not everyone that helps is Ray.

If you remove those characters, how do you expect the lookup to succeed? What does the data look like that you are trying to match it to?

Nothing "weird" about them, it's French for "City of Youth".

... and away we go.

I believe that all will. I specifically mentioned && as it is a conditional separator, meaning the second command will only execute if the first 'succeeds'. With a semi-colon the second one executes regardless of the fate of the first. Use whichever is appropriate.

OSes.

Not sure where the "write it to a file" part is coming from but the other advice is solid.

Neither one of those is a date but rather strings. So either cut it up and put it back together the way you want or go StringToDate() and then DateToString() with the proper format masks.

Haven't given this much thought but first thing I noticed was the fact that you are piping the two commands together. Replace the pipe with && for a proper conditional break between the two.

I honestly don't know how well the SCD stage supports Type1 but I'm sure someone does and will chime in.

Still best to start your own topic, so... splitted.

Googling for your error turned this and similar things up, it does seem like you haven't properly specified the SMTP server. Check with your Admin what it should be.

Yah, no XMETA anything pre-8.

Hmmm... I don't think we're all on the same page here.

Well, someone let us know what stage we're talking about here.

You can always delete your own messages as long as no-one has replied to them yet. After that, I nuke them.