AnsweredAssumed Answered

SQL via ODBC fields separated by ¶?

Question asked by richard2 on May 29, 2018
Latest reply on May 29, 2018 by wimdecorte

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?