sql statement

how can i concatenate the string for example i need to use where clause in a sql statement and match with a variable as it is done in vb or java.....

i mean something like this:
vb code:
str1 = "select * from table where fld1 = '" & var1 & "'"

How can i do this in VC++

Thanks
waqas

you could use sprintf

memcpy, strcat, sprintf, wsprintf (windows only)

Thanks guys, it solved my problem....

waqas