DELETE END OF STRING 1

[100dtl]

What can delete the end of theis string for me??

or sku like '*4505' or sku =


I need

or sku =


taking off

 

[MacLeod72]

Based on that EXACT String:

cStr = "or sku like '*4505' or sku ="
cStr = Left(InStrRev(cStr, "'" + 1))

That should leave you with "or sku like '*4505'"

--Rob

 

[100dtl]

Didnt work,.. thisiis my typical string

update products set boxnumber = 'BX602701' where sku= '3000000003' or sku like '*0003' or sku ='3000000034' or sku like '*0034' or sku ='3000000095' or sku like '*0095' or sku ='3000000095' or sku like '*0095' or sku ='3000000272' or sku like '*0272' or sku ='3000000288' or sku like '*0288' or sku ='3000000289' or sku like '*0289' or sku ='3000000951' or sku like '*0951' or sku ='3000000980' or sku like '*0980' or sku ='3000003019' or sku like '*3019' or sku ='3000003139' or sku like '*3139' or sku ='3000003892' or sku like '*3892' or sku ='3000004352' or sku like '*4352' or sku ='3000004505' or sku like '*4505' or sku


I want to trim the end off

 

[100dtl]

This fixed it

sql = Left(sql,len(sql) - 8)