Re: [SQL] How do I remove selected words from text field?

2010-07-01 Thread Frank Bax
Osvaldo Kussama wrote: 2010/7/1 Frank Bax : Create some tables; then add some data: create table t1 (i int, v varchar); insert into t1 values(1,'A B C D'); insert into t1 values(2,'B D E F'); insert into t1 values(3,'G H I J'); insert into t1 values(4,'E'); create table t2 (q varchar, z varchar

Re: [SQL] How do I remove selected words from text field?

2010-07-01 Thread Osvaldo Kussama
2010/7/1 Frank Bax : > > Create some tables; then add some data: > > create table t1 (i int, v varchar); > insert into t1 values(1,'A B C D'); > insert into t1 values(2,'B D E F'); > insert into t1 values(3,'G H I J'); > insert into t1 values(4,'E'); > create table t2 (q varchar, z varchar); > inse

Re: [SQL] How do I remove selected words from text field?

2010-07-01 Thread Frank Bax
Create some tables; then add some data: create table t1 (i int, v varchar); insert into t1 values(1,'A B C D'); insert into t1 values(2,'B D E F'); insert into t1 values(3,'G H I J'); insert into t1 values(4,'E'); create table t2 (q varchar, z varchar); insert into t2 values('A','vowel'); insert