date problem

[zedan]

Hi
i m trying to build a Query using VB6 but i have problem in using *
this is my Query
"select max(cus_code) from cus_data where cus_code like "&num&"*"
so how can i solve it??
thanks

[Krzemo]

"select max(cus_code) from cus_data where cus_code like '" & num & "*'"

[srikanthvja]

make sure column in where clause is char datatype