SELECT SUBSTRING(AccountNo, 0, LEN(AccountNo)-(CHARINDEX('-', AccountNo) +1)) FROM account
no such function: SUBSTRING: SELECT SUBSTRING(AccountNo, 0, LEN(AccountNo)-(CHARINDEX('-', AccountNo) +1)) FROM account
substr
CHARINDEX
instr
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)