>Can't parse well, but I can at least do my sql select in an acceptable manner for pulling ranges... I had to add a space to the PATINDEX parameters, however, it returns 28 for 28 1/2 because I cannot go by the / because 28[space]1 does not convert to an integer... I guess nothing is perfect - close enough though because chances are a search by range would include only the whole number anyway.
These are street names, not numbers, so you'd have something like
"1089 24 1/2 st" (or "1089 24th 1/2 st", wouldn't know offhand) for street address, so it should stop at 1089 anyway.
Something to add to your connundrum. My street number has a dash in it - for some reason, they didn't number each house separately, nor have they assigned apartment numbers, but applied a nnn-1, nnn-2, ... numbering scheme. USPS translates this into "nnn street apt 3", but all city paperwork comes with a dash.