Off Topic but has anyone else noticed the Trend for the last three
months is "Help my boss, customer, friend" wants to get ALL his columns, all
his data or all his junk out of U2, and I'm not worried about getting it back
in... I'm in the opposite boat, I want to leave it in there, and I'm VERY
comfortable with SQL Server, I'd rather they work together than choose one
technology over the other.
My Question today is, if I'm writing a quick "view" in SQL Server I can
write a nice little function to strip a field to just it's alpha numeric
characters. Then I'll be using this on a webpage to strip the Input of it's
non-alphanumeric characters as well, thus showing more matches when values are
entered for (in this case) part numbers were entered in an odd fashion.
Example: User enters "1-2-3-4"
My data for a Part Number, might have
1-2-34
12-34
AND
123-4
My systems on the Intranet (Employees only) would say "no matches
found" I'm not ok with this response. I think a direct match should be done
first, but THEN additional searches are done, I even have a fuzzy one off
Search using the SQL single Char replace (using _ based on the LEN of the
input) and then a massive union query. However I want to do this in our
UniVerse system instead, as that's where the data truly resides, and so I would
hope would be the fastest place to run this type of search.
I have no idea how to write an I type or Paragraph or Subroutine that
will take a string in as the Variable and then pass back another string
stripped to the AlphaNumeric only response so that I can search it. I'm
assuming a Subroutine would do the trick and then I can use that Sub in an Dict
Entry as an Type I, no? Where to begin? >.<
Thanks for your time,
-
John J. Wahl
Employee Owner
Programmer / Analyst (Born in Microsoft, but now a U2 lover...)
Tel: (330) 528-0091 Ext. 120
Fax: (330) 655-8458
Email: [email protected]
Web: http://www.Joseph.com/
If the ship is not sinking why are you all jumping off?
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
