embedding variable inside sql statement

Well I finally managed to get my connection issue worked out and use a select statement in my program, but I am new pointers and stuck with using variables inside my sql statement

CString *myvariable;

*myvariable = m_UserInputVariable;

sqlStatement("SELECT from Table where name like '&myvariable%'")

I am very new to pointers and not even sure if I'm heading in the right direction. Can anyone show me an example or point me to the direction of how I might accomplish this?

I apologize for the horrible code tag usage, I will be reviewing the documentation on this site directly.

Thanks for any help.

Never mind, I found a way to do it without pointers, after reading more on pointers they did not see the way to go, so I used a series of CStrings and them pass that to the CRecordset:: class and it seemed to work.