awk question

From: Joe LaCascio <jlacasci_at_wheatonma.edu>
Date: Fri, 10 Aug 2001 10:06:00 -0400 (EDT)

How can I get awk to produce a singe quote in my output file?

For example:

awk '{print $1 ", " $2 ", " 'CA'}' some_file > foo

assuming some_file contained

Bob Smith

I'd like the output to be

Bob, Smith, 'CA'

Thanks,
Joe
Received on Fri Aug 10 2001 - 14:06:47 NZST