Hi,

If you want to use DD/MM/YYYY style pattern then you need add the parameter style number 103.

Here is the example,

Declare @temp table

(

i datetime

)

Insert into @temp values ('2006-03-30 12:46:11.700')

select convert(varchar(10),i,103) from...

Hi ,

Here is sample solution. Just you need to add the loop for this solution.

Here I am taking only one string example.

Declare @temp2 table

(

city varchar(20),

state varchar(20)

)

Declare @string varchar(20)

set @string='NewYork,USA'

Declare @i...