declare @nvsDateTime NVARCHAR(20)

set @nvsDateTime = '1330'

select REVERSE(SUBSTRING(REVERSE(@nvsDateTime),0,3) + ':' + SUBSTRING(REVERSE(@nvsDateTime),3,LEN(REVERSE(@nvsDateTime))))

try this.....

Exactly what you want?

Are you getting error after implementing cascade option or wanting to use this cascade option?

Thanks gail.

Where can i get the detail of this(no point should be missed)?

And one more doubt.

How these things are communicated to memory?

If you are using sql server 2005, then use VARCHAR(MAX) datatype instead of text datatype.

if you are using sql server 2000, then you have to first split the string to...