Hello,

I am using SQL Server 2000 as a back end. I receive Excel files with some
information and i import that information into SQL Server. Now I have a
problem with one of the fields in the file.One user sends it in format 'MAY
2007' while another sends it as 'MAY 07'. I need to get the data into one
table in the format 'MMYY' i.e 0507. No issues in importing as it is very
fast.I am able to make some progress in the first case which has data in the
format 'MAY 2007' as i am able to convert it into date format and then use an
update statement to get it in desired format. But in the second case both the
convert and cast are failing and I am held up here. I request you to help me
in this regard.

Thanks,

Pradeep Varma

Clustered Index Not Working
Select distinct problems
Top 1 query problem
UPDATE varchar(max) column using INNER JOIN with SQL2005
Newbie question for Report Server