# 3557 SQL RIGHT() Function Not Working Properly When If Number of Characters Is Less Than Argument

---

I have found that the right() function in SQL does not work properly.

Take a string col of width 24. Put some values in there that are say 10,11, 12 and 13 chars wideThen execute the following SQL.

This is what you get for different lengths:

10: Empty
11: Weird CTL Char followed by the 11 chars
12: 12 chars
13: 12 chars

So if you have LESS than the # of chars you want returned from the column you either get bad dad (with the CTRL char) or no data.