Wednesday, March 16, 2011

How to Use Trim in Sql

Trim from Right Hand Side

select serial_num, Rtrim(imagePath) from Tbl_EmpDetails

Trim from Light Hand Side

select serial_num,Ltrim(imagePath) from Tbl_EmpDetails


0 comments:

Post a Comment