single quotes within insert/update stmts

I have an insert stmt as follows:

insert into user_profile values ('username', 'select.....');

within the 2nd argument ('select.....') there exists several single quotes (')
How can I modify the stmt so that the insert doesnt get confused between single qutes within the argument to be inserted and the final single quote to delimit the argument.

Any possible Suggestions would be helpful

Thanks

Anit Received on Thu Feb 24 2000 - 09:21:09 CST