If you search this site for 'Search DTS for string' you'll see several leads.

Is this a a 2000 server or a 2005 server with legacy DTS packages?

Also keep in mind that you can export the packages to xml files and then do a search/replace using a text editor and then re-import. Perhaps this could help depending...

>>Here's my situation: I have to refresh table data nightly; however I need to leave everything else (procedures, views, stored procedures) intact.

Maybe you can script out all the views and...

Is there an existing application or reporting tool that already is writing or retrieving data against the data?

If so you can run the SQL Server Profiler tool to see what...

Thank you both. This has been educational and I have been able to unequivocally demonstrate to my very expensive and supposedly enterprise-level vendor that their product is just not very...

Thank you so much. A few more questions if I may.

Am I correct in thinking that this character may not show up, that is be visible, in a normal text...

I get this

subloc(No column name)

148

246

357

457

513

SELECT'*'+IssuerValue+'*' returns '*0.99 *' as an example. It appears to be a space. If I add IssuerValue LIKE '% ' to my WHERE statement nothing is returned.

ISNUMERIC(IssuerValue) = 0 returns...

I checked in a...

Here is a kludge possible solution if you really want it.

Create a a master generic table with enough columns to accommodate your widest result set. They'll probably need to be...

Oh I'm sorry you answered that question. Are the three sections side by side or underneath each other?

Are the three result set identical as far as columns? Can you UNION them together?

Thanks, this is what I call actionable intelligence. Its a vm system so hopefully may admin can easily bump it up...

How about this update statement?

UPDATE CLI_CleanUp

SET CLI = stuff (CLI, patindex( '%[^0-9]%', CLI),1,'')

WHERE patindex( '%[^0-9]%',CLI) <>0

Thank you GSquared.

I have an 'AttributeDataType' field in my Attributes tables which has a constraint limiting that field to either 'Numeric' or 'Character'.

Is it possible for my 'one or...