It Did not worked

No No its not home work or technical screening? can you please provide any

resource for solving this.

Thanks Mike.

Can you give me some example or reference link.

Rob Schripsemasolution Solves my ISSUE.

Thanks Guys. I got it now.

Thanks John

but your solution is creating new table called @CharDates

say suposse if my base table has 2 lakh records...

Yes i know the error is due to invalid date.

is there any way that we fix this using tsql code

Thanks

Kishore

Yes i had like 2lakh records. i cant change the datatype of table to datetime. i need to fix it through query only.

Thanks

Kishore

Dont worry i was done.

create function allowableRaceValues(@Raceval varchar(20))

Returns int

AS

BEGIN

declare @output int

declare @ie varchar(5)

set @output=1

declare @i int

declare @ctvar int

set @i=1

set @ctvar=len(LTRIM(RTRIM(@Raceval)))

while (@ctvar>@i)

Begin

set @ie = RTRIM(LTRIM(substring(@Raceval, @i, 1)))

IF(@ie) IN ('I','N','A','B','P')

set @i=@i+1

ELSE

BEGIN

set...

Thankyou

Mark

AND

Lynn Pettis

Thankyou Guys.

this is what i tried

Declare @ss varchar(100), @idx int

declare @tlen int, @tss varchar(100)

Set @ss = 'kishore'

set @idx = 1

set @tss = ''

select @tlen = len(@ss)

While (@tlen+1 > @idx )

Begin

print...

if i call inesrtcomma(AW) it needs to return A,W

insertcomma(BWI) it needs to return B,W,I

...