Hi James Harkins,
Unfortunately it is not possible to use wildcards against numeric fields. What you can do however is take advantage of the built in conversation methods in SQL and convert your integer field to string and then apply a wildcard search on it. This should look something similar to this:
var result = scope.GetSqlQuery(
"SELECT * FROM Categories WHERE CONVERT(varchar(20),CategoryID) LIKE '1%'"
I hope that helps.
the Telerik team
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Telerik Public Issue Tracking
system and vote to affect the priority of the items.