hello @Ruijia - great question, thanks for posting!!
can you try using CONCAT('N', $input$) in the SQL query?? I would try on your behalf, but don’t have MS SQL to test unfortunately.
I’m also eager to hear input from others if someone has come across this.