Help get this topic noticed by sharing it on Twitter, Facebook, or email.

LIKE Condition not working, and CONTAINS throws error.

Cannot use LIKE condition on sys_sfobjects. Also using CONTAINS returns an error.

1.) LIKE
SELECT Name FROM SALESFORCE...sys_sfobjects WHERE Name NOT LIKE 'npe4%'

Doesn't return any records.

2.) CONTAINS
SELECT Name FROM SALESFORCE...sys_sfobjects WHERE CONTAINS(Name, 'npe4')

Returns an error:
OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE" returned message "Error 13005 : unexpected char: '['".
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE".
1 person has
this problem
+1
Reply