I'm building a file with sql delete statements. I need to print the single quotes for the where clause.

i.e.
delete from Command where CommandName = 'SomeName';

I have the following in my script

input=$(pwd)/Cmnd.csv

i=0

while read line
do
if test $i -ge 1;
then
echo "$line" | awk -F'|' '{print "delete from Command where CommandName='"$1"';}' >> deleteCmd.dat

fi

i=$i+1
done < $input
This gives me:
delete from Command where CommandName=;

how do I print the (single quotes) ' with awk?

In Perl, you have to replace it with:

I saw something on Google which showed this in awk:

And for what it's worth, this prints a single quote in bash: