I have input data in store procedure like 'ab|BC|CD|DE|' i need to remove last pipe symbol in sql query give any ideas friends ...