I've run into a bit of a problem, I'm querying a filemaker database via ODBC from Python and I'm having an issue with fields that contain multiple values.
for example, in filemaker the field shows:
but when i click into it it shows the data I need:
problem is SQL brings back the first example. And this causes a problem when I'm trying to search for these number I'm not getting a match.
When the numbers have been added to the field they have been added with a ¶ at the end of each line.
The Field is set as 'Number' and options are 'Indexed'
Any ideas why it's doing this?