https://community.qlik.com/t5/App-Development/Source-Lookup-with-a-special-character/m-p/1820814#M67289 <P>Hi,</P><P>I am using source_lookup on iSeries database to fetch data from other table. However, the columns contain special characters such as #. The following is a simple source_lookup that is failing to execute:</P><P>source_lookup(10000,'SCHEMA','TABLE','COLUMN_NAME','RQMEM#=?',$EMLMEM#)</P><P>The Parse expression fails to recognize the # character as a string. I have tried the below as well:</P><P>source_lookup(10000,'SCHEMA','TABLE','COLUMN_NAME','RQMEM#=?',$EMLMEM AND CHR(35)) and get this error "no such function CHR".&nbsp;</P><P>Kindly advise.</P> Thu, 08 Jul 2021 18:52:28 GMT nkare_nts 2021-07-08T18:52:28Z https://community.qlik.com/t5/App-Development/Source-Lookup-with-a-special-character/m-p/1820814#M67289 <P>Hi,</P><P>I am using source_lookup on iSeries database to fetch data from other table. However, the columns contain special characters such as #. The following is a simple source_lookup that is failing to execute:</P><P>source_lookup(10000,'SCHEMA','TABLE','COLUMN_NAME','RQMEM#=?',$EMLMEM#)</P><P>The Parse expression fails to recognize the # character as a string. I have tried the below as well:</P><P>source_lookup(10000,'SCHEMA','TABLE','COLUMN_NAME','RQMEM#=?',$EMLMEM AND CHR(35)) and get this error "no such function CHR".&nbsp;</P><P>Kindly advise.</P> Thu, 08 Jul 2021 18:52:28 GMT https://community.qlik.com/t5/App-Development/Source-Lookup-with-a-special-character/m-p/1820814#M67289 nkare_nts 2021-07-08T18:52:28Z