[/quote]

How about creating the new column and filling it with the converted data, add the appropriate indexes, then convert the old column to a computed column? Your existing code can continue to address the old column but in new code (or as needed) you use the new column.

- Les[/quote]

This would not be helpful since the column with correct datatype is required to be used by all queries.

However, I have solved the problem by unbinding the SP and then binding them again. Thanks