"14,000 Employees (ITO/Atlanta)"
"144,321 Employees (CS/SanRamon)"
My goal is to order them first by the text within the parentheses, and second by the number at the front of the string. The following syntax works for the first part (ordering by the text within the parentheses), but not for the second part (ordering by the number). Is it because I am not forcing the string to an integer correctly with the '+0' ??
Code: Select all
ORDER BY SUBSTR(ls_employee, POSITION('(' IN ls_employee)),0+substr(ls_employee, 1, 5) $_REQUEST[odir]