I handle this in other places using the replace () function, but I can't figure out how to replace a ' in the database with a '' in the result.

A Function Arguments dialog box will appear. The process is explained in method one for the Function Arguments dialog box. Read: How to use the Find and FindB functions in Excel.

SQL Window functions are an advanced type of function in SQL. In this post, you will learn about what SQL window functions are and how they can be used or work.