LEFTB equivalent in SQL queries?
Is it possible, in an SQL query, to take the results from a column and run the equivalent of an Excel LEFTB on them, that is trim everything apart from the first n characters from the result?
Likewise, can the reverse be done, trim the first X characters and return everything else?
Likewise, can the reverse be done, trim the first X characters and return everything else?