in reply to Re: Yet another problem
in thread Rewritting SQL table definition

Thanks for the help. Now, how about putting single qoutes (') around the Y and N only. In the same command.
Thanks
Bobby

Replies are listed 'Best First'.
Re: Re: Re: Yet another problem
by fglock (Vicar) on Sep 27, 2002 at 20:14 UTC
    s|\(Y,N,|\('Y','N',|;

    should do it safely, unless you expect to find spaces between these characters (then you must add some \b* in some places).