hello everyone,
I'd like to know how would i state a SELECT statement that finds me words in a column "NAME" that begin with a space and followed by a word.
e.g. ' John' , ' Peter', ' Paul'
where name like ' %' should work. If you're doing this to remove the space, just update name = ltrim(name).
it worked thanks a lot
