Syscomments.text And Visual Basic 6

Has anyone experienced problems calling stored procedures that references syscomments.text from Visual Basic 6?
I have a stored procedure that finds all tables referenced by a specific stored procedure. It works well when I call it from SQL Server Management Studio, but there are cases where it does not find the tables when I call it from VB 6.
I've isolated the failure it to a specific condition in the WHERE clause:


SELECT @howfar = so.id

FROM SYSOBJECTS so

LEFT OUTER JOIN syscomments sc on so.ID = sc.ID

Where lower(so.name) = lower('storedProcName')

AND lower(sc.TEXT) LIKE '%' + lower('update') + ' ' + lower('tableName') + '%'

The call from VB works (finds the record) if

" AND lower(sc.TEXT) LIKE '%' + lower('update') + ' ' + lower('tableName') + '%' "

is omitted, and fails (does not find any records, no error is raised) if that condition is included.

I should also add that the VB Call does work for some combinations of stored procedures and tables.
The old SET NOCOUNT ON trick does not make any difference.