hi all,

I have been trying to use a sql like statement with a variable and it doesn't seem to be working...

.....fieldname LIKE 'variable%'
...... " " variable%
...... " " "'variable%'"

Does anybody know the proper syntax?...I know it's possible to do it in ASP so it has to be possible in VB

Thanx in advance

SozeWun