Sunday, 4 December 2016

Left Right Function

Query :
select docpath,RIGHT(DocPath,len(docpath)-47) as RH,LEFT(DocPath,47)LH from FeasChecklistDocument where TranMasId = 200 and TranId = 1

Result:
docpath  =  \\dataserver\SFPL System\Doc\Marketing\Enquiry\fgs02722_04.03.2016.pdf
RH         =  fgs02722_04.03.2016.pdf
LH         =  \\dataserver\SFPL System\Doc\Marketing\Enquiry\

No comments:

Post a Comment