are you looking fto simply REPLACE of ~~ with CR? or is it more complex than that?

SELECT TblC1.Client AS Expr1, REPLACE(TblC2.strAddr,'~~','CR') AS Expr2

FROM ...

it depends on what you want to do, of course....say that if it's 7 characters, do you you do anything at all? do you only strip off the first character,...

the issue you are running into is the account SQL server is running under is not an account that has access to teh network. jobs run under the security context...

a combination of using substring and a where statement will do the job; you might need to tweak the WHERE statemtn...are you sure it's only items that are exactly 8...

i think the update is this:

UPDATE TableA

SET TableA.[Cap Code] = TableB.CapCode

FROM TableB

WHERE (((TableB.CapCode) Is Null) AND ((TableB.FromDate)

Between [Effect Date] And [Term Date]))

OR (((TableB.CapCode) Is...

your too fast for me...once a path gets too many levels deep, i like screenshots too.

yep it sure does: Tools>>Options

avoid doing anything in a trigger not realted DIRECTLY to the data...an activex object could cause the trigger to rollback, or lock the table as the trigger waits for the...

I think something using BETWEEN would be my suggestion:

AND d2.trade_date BETWEEN getdate() -730 AND getdate()

or

AND d2.trade_date BETWEEN '01/01/2007' and '01/01/2008'

i had a similar issue with an Oracle provider; the provider would strip out/replace CrLf and tabs with a space in a statement being executed...

so a statment like this:

SELECT STUFF,

MORESTUFF...

you'll get better responses if you can post what you are actually doing...theoretical questions get loosy goosy answers...the more detailed your question, the more detailed an answer you can receive.

you...

the trick is to use the REVERSE function and charindex.

I've broken it down step by step so you can see what's happening, along with a final long formula:

[font="Courier New"]

DECLARE @str...

what you want to do is look at the books online examples for sp_executesql; look specifically at the OUTPUT parameters.

here's an example directly modified from BOL: I'm selecting an arbitrary...

well the KB article mentions it might take a long time for a trigger to compile, depending on the trigger.... since it just takes a while, but still works, i...

ok, I'm making a lot of assumptions, like ther emust be 3 more items added for EVERY item that's in your sample table. if an item overlaps where id_3, you...