It is a VBA function, so it can't be used directly in a SQL query. You can either process the string using Split() in VBA or you can create a custom function which uses Split() and, from what I've researched, you can use custom functions in SQL queries.
There's an excellent answer on Stack...