Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abenitez77
Yak Posting Veteran
53 Posts |
 Posted - 2010-10-01 : 12:30:31
|
| I have a column that holds vendor names (Vendordesc) and I want to query the table/column to pull all the vendors. This table has records where I see "??????", "&I", "(?+?)?????", etc... I want to keep the funny chars if they are used with valid vendor names and it is not in the beginning of a vendor name. I also have recs with valid vendor names but that start with funny chars that should not be there (ie "/ vendor name", "+Vendor name", ";Vendor name"). I also have Vendor names that are in double quotes, I want to keep that the way it is (ie "Vendor name"). I am querying this to put it in a dropdown field in ms access so that I can select a vendor. I am creating a view so that I can pull the column from the view. How do I query this in TSQL for my view? |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-10-01 : 12:50:48
|
| Try thisSelect Vendordesc from yourtablewhere Vendordesc like '[a-z,A-Z,"]%' |
 |
|
|
|
|
|
No Funny Chars