Brent,
Both worked like a charm. Thank you so much.
I kicked myself for not thinking of CONCAT.
Yes, Filemaker joy. Actually I have another word in mind. But with
you help and expertise we are slowly walking away from Filemaker.
Erik
On Jul 14, 2006, at 7:02 AM, Brent Baisley wrote:
Aaaah the joys of importing data from FileMaker. Repeating fields, gr.
You need to do an ASCII/CHAR conversion since vertical tab is a "non-printable"
character.
select *
from accounts
where billing_address_street LIKE CONCAT("%",CHAR(11),"%")
Since this is problem a one shot deal and you a
