Hi,
You can use SUBSTRING function as follows...
But I don't think so, Where you will use this...
SELECT SUBSTRING(Col_Name,1,256) 'ResultCol1',
CASE WHEN LEN(Col_Name) > 256 THEN SUBSTRING(Col_Name,256,512) ELSE NULL END 'ResultCol2',
CASE WHEN LEN(Col_Name) > 512 THEN SUBSTRING(Col_Name,512,768) ELSE NULL END 'ResultCol3',
FROM table Name
GVPrabu