I have a field in Oracle that has a blank character at the end so instead of it reading "12345" it reads "12345 "
The length of this field differs on different records but may also have a blank at the end. How may I write in SQL to identify those records that have a blank at the end?
try this
Select ColumnName from tablename where columnname like '% '
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments