Dave Clarke
2009-08-24 23:24:58 UTC
I've been trying to use PATINDEX in SQL Server CE and it isn't
behaving the way I would like it to. I'm trying to strip leading
characters from a street address to return a meaningful street name.
e.g. DISTINCT PATINDEX('%[^0-9, ]%', Address1)
For addresses like '123 Some Street' this works in SQL Server but not
in CE. I'm currently doing this processing using C# to get a list of
distinct streets and I was hoping to gain some speedup by getting the
database to do the heavy lifting. Any suggestions re alternative
approaches would be much appreciated.
behaving the way I would like it to. I'm trying to strip leading
characters from a street address to return a meaningful street name.
e.g. DISTINCT PATINDEX('%[^0-9, ]%', Address1)
For addresses like '123 Some Street' this works in SQL Server but not
in CE. I'm currently doing this processing using C# to get a list of
distinct streets and I was hoping to gain some speedup by getting the
database to do the heavy lifting. Any suggestions re alternative
approaches would be much appreciated.