> b> hi,
> b> Using the following line in my awk program doesn't yield the single
> b> quote i am looking for in my output:
> b> printf("delete from bin_inv where (serial_nbr = RTRIM('%s'))
> You seem to be missing four things from this statement:
> a) Closing quote
> b) String to sub into %s
> c) Closing paren for the printf
> d) Following semicolon
Semicolons are only necessary when you want more than one
statement on a line. Printf statements do not take parentheses -
you can use them, but they are treated as any other parenthetical
statement. They can mask problems. Awk isn't 'C'.
> printf("delete from bin_inv where (serial_nbr = RTRIM('%s'))", foo);
> Where foo is an initialized string
Opinions expressed herein are my own and may not represent those of my employer.