Hi All,
I need some trigger help. I am very new to SQL, so please bare with me.
I have a table:
CREATE TABLE table (
id integer,
name text,
);
Basically, I have values going into name.
The values that go into name are like this (being generated by a script),
without the quotes:
" name1"
"name2"
" name3"
" name4"
"name5 "
I want to write a trigger, for UPDATE/INSERT, do a ltrim and rtrim() of name
value. I want to remove all the beginning and ending blank spaces.
I want name to be like this:
"name1"
"name2"
"name3"
"name4"
"name5"
Is that possible?
TIA