@dwain.c

Thank you...it worked...:)

SELECT ID, FID, HC, VC, SN, updateddate

FROM

(

SELECT ID, FID, HC, VC, SN, updateddate

,rn=ROW_NUMBER() OVER (PARTITION BY...

@ Sean Lange

Thank you...

@kapil

Thank you

@jeff Moden

Thank you..

DECLARE @d varchar(6) = '20114'

SELECT try_convert(date, substring(@d, 1, 4) +

CASE WHEN len(@d) = 5 THEN '0' ELSE '' END +

substring(@d, 5, 2) + '01')

This worked but I am not...

DECLARE @d varchar(6) = '20114'

SELECT try_convert(date, substring(@d, 1, 4) +

...

I tried this but it is not working

Actually 2011 is year and 4 is month which shoud be represented as 04 and date is 01 (which is to be added)

I need this column data to...

Thank you..and actually it is a column that stores data as varchar and data is like this

start date

------------

20114 ----2011 is year and 4 is month

20113

20112

20105

20106

I need to represent above data...

2011 is year

4 month

01 is day

I need to convert it to 2011401 and need to use convert..Thank you