Calling an SQL function from a Subsonic.Select

I asked the following question on the subsonic forum, but only seemed to get one response, so I thought I'd post up here as well to see if anyone could shed some more light on the problem…

I wish to create the following SQL statement through SubSonic using the Select tool (or Query tool) .. it uses a custom function called "SPLIT()":

SELECT * FROM VwPropertyList
WHERE VwPropertyList.idCreatedBy = 123
AND VwPropertyList.idCounty = 45
AND 29 IN (SELECT Item FROM SPLIT(DistrictGroupList, ','))

(the last part of this SQL uses the SPLIT function)

My subsonic equivalent looks like the following…

Dim mySelect As New SubSonic.Select
mySelect.From(VwPropertyList.Schema)
mySelect.Where(VwPropertyList.Columns.IdCreatedBy).IsEqualTo(123)
mySelect.And(VwPropertyList.Columns.IdCounty).IsEqualTo(45)
mySelect.And(29).In(New SubSonic.Select("Item").From("SPLIT("
&
VwPropertyList.Columns.DistrictGroupList
& ", ',')"))

This doesn't work though due to the last part .. how can I add "AND 29 IN (SELECT Item FROM SPLIT(DistrictGroupList, ','))" into my Subsonic.Select ?

The response I got from the subsonic forum suggested I do away with Subsonic.Select and replace with hard-coded InlineQuery() statements .. like:

Dim SQL as String = "Select " &
VwPropertyList.Columns.Item
SQL = SQL
& " From " &
VwPropertyList.Schema.TableName
SQL =
SQL & " Where " &
VwPropertyList.Columns.IdCreatedBy & "
= @CreatedBy "
SQL = SQL & " And " & VwPropertyList.Columns.IdCounty & " =
@County "
SQL = SQL & " And
@DistrictGroup IN (Select Item From
SPLIT(DistrictGroupList,',')"

Items =
SubSonic.InlineQuery().ExecuteTypedList(Of
MyItem)(SQL, 123,45,29)

I would prefer to use SubSonic.Select if possible though so that I can avail of the paging functionality etc.

Any ideas?