It went into...

I removed the function from the WHERE and replaced it with a local variable:

AND CD_DW_INSERT_DATE > @Date

I got another problem on a JOIN.

Found filtering columns wrapped inside User-Defined Function...

Thanks Kraig.

I run it through ubitsoft's T-SQL Analyzer and I get the following:

SA0028 : [Deprecated]Function call can be extracted from the WHERE clause to avoid...

I get the following warning when using SQL Enlight:

Avoid using ISNUMERIC function as it accepts floating point and monetary number.

David McKinney (1/15/2014)

---

I may be missing your point, but when I go into Tools / Options / SQL Server Object Explorer / Scripting, I can set script indexes to true....

Thanks for the replies.

The following worked:

SUBSTRING(Inception,6,2) + "/" + SUBSTRING(Inception,9,2) + "/" + SUBSTRING(Inception,1,4)

I tried using the following expression and it is not valid syntax. Can not parse.

I had to change the Column from Inception which I defined to Column 8 as well.

(DT_WSTR,...

I hope that this is enough information.

Source:

6600154038120140301REN|XO|XO||FL|81|660015403|2010-03-01 00:00:00|03/01/2014|12|

Destination Desired Output:

6600154038120140301REN|XO|XO||FL|81|660015403|03/01/2010|03/01/2014|

Thank you.

:crazy:

I was thinking that it might have been...

Thanks Lynn. 🙂

Luis Cazares (1/9/2014)

---

Oh my, so much code! My laziness wants to write less.

declare @SSDate datetime = '20140109'

declare @CharSSDate char(10)

SELECT CONVERT( char(10), @SSDate, 103), --4-digit year

STUFF( CONVERT( char(10), @SSDate, 103),...

Sorry about the Year.

It first was...

I got it.

,RIGHT('0' + CAST(DATEPART(mm,PURCHASE_DATE) as varchar(2)),2)+ '/' +

RIGHT('0' + CAST(DATEPART(dd,PURCHASE_DATE) as varchar(2)),2)+ '/' +

CAST(DATEPART(yyyy,PURCHASE_DATE) as varchar(4))...

The tables are small.

Thanks.