On 10 Mar, 2012, at 7:06 pm, Cifer Lee wrote:
> when we call procedure
> normally we declare the parameter out of the procedure and pass the
> variable to procedure
> like this
>
> set @x=1;
> call *a_procedure*(@x);
>
> why can not directly pass the digit 1 to the* a_procedure* ?
You can pa
2012/03/08 16:11 -0500, Hank
I have a varchar field in the database, and I want to remove all text
between WordA and WordB, including WordA and WordB, leaving all text
before WordA and after WordB intact.
Possible with just SQL? I know I can write a PHP program to do it,
but it's not th