in reply to Rewritting SQL table definition

simply on the next line under IS_ONE_TO_ONE

Is this ok?

s/\bCHECK\b/,\n CHECK /i;

Replies are listed 'Best First'.
Re: Re: Yet another problem
by curtisb (Monk) on Sep 27, 2002 at 20:09 UTC
    Thanks for the help. Now, how about putting single qoutes (') around the Y and N only. In the same command.
    Thanks
    Bobby
[reply]
      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).

[reply]
[d/l]

In Section Seekers of Perl Wisdom