LOWER SQL function only works on text/varchar data type column

So we need to use it after casting the column to CHAR.