select * from dbo_tp_airline where AirlineCode like '%KL#NW%'

this is not a valid MySql command?

How can i get round this to allow for the '#'? It is stored in the DB as KL#NW???

Picco

__________________
_______________________
Ayrshire Minis - a Mini E-Community
http://www.ayrshireminis.com
http://www.crmpicco.co.uk

select * from authors where au_lname like '%#%' worked for me in SQL Server 2000

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

oops you have mentioned MySQL !! as this is a SQL Server group I presumed your post is for sql server :)

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com