remove line breaks from SQL

[woodie63]

Hi, a bit of a newb to filemaker & SQL but have got things working ok

I'm using the Actual ODBC Driver Pack with FM8

I can connect to my mysql database and insert into tables etc.

I have a field in my FM database that is based on a value list

probably a silly question but how do I remove line breaks from my value list output so it doesnt break my sql query?

any thoughts much appreciated

cheers!

Peter

[woodie63]

....cont

I didn't find an answer to this question but...

I traced the problem with my sql down to something else!

problem solved, I think...