MS SQL Server CHARINDEX, SUBSTRING functions

[OpenIT Solutions]

Any idea why i get an error when trying to use these functions in a model search against my MS SQL Server OLE DB connection within EA ?

Thanks,

Jon.

[Geert Bellekens]

I just tested this in an SQL Search:

Code: [Select]

select CHARINDEX('a',d.name) as test from t_diagram dand it came back perfectly fine.

I'm using SQL Server  2008 with 'SQL Server Native Client 10.0' to connect to it.

Geert

[abruckner]

charindex: allowed column types are: char/varchar,nchar/nvarchar, and binary/varbinary.