Re: [MS_AccessPros] Re: filtering out non printable characters

At this point, the only one that's come up is the tab character. I still
can't find anything about why Access would show it and SS Management Studio
won't ....

So, I'll give it a shot and let you know if that helps :)

~*~*~*~*~*~*~
Shay Bella Holmes
~*~*~*~*~*~*~

On Tue, Aug 30, 2011 at 8:44 AM, Bill Mosca <wrmosca@comcast.net> wrote:

> **
>
>
> Shay
>
> Is it always the same character? if so, you will need to get the ASCII
> number for it and use Replace().
>
> Let's say the unprintable character is a Tab. ASCII number is 9.
>
> SELECT Replace([MyField],chr(9),"") As MyFixedField
> FROM MyTable
>
> Replace() is not going to actually change the data. It just temporarily
> changes the result as it appears in the recortdset.
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile/Bill.Mosca
>
>
> --- In MS_Access_Professionals@yahoogroups.com, Shay Holmes
> <shaybellaholmes@...> wrote:
> >
> > Working with Access 2010 & SQL Server 2008 has given me 2 questions ...
> >
> > 1) Why would Access show a non printable character that SSMS does not
> show?
> > 2) How can I write a query (in T-SQL if not ANSI 92 SQL) that returns
> only
> > non zero length & printable characters? I cannot change anything to do
> with
> > SQL Server; I can only read from the tables.
> >
> > I tested my pass through queries in SSMS and it all looks fine, but when
> I
> > display one of them in Access I'm seeing a non-printable character (a tab
> > character) in the last column of a SELECT * FROM [table] pass through
> (query
> > is for data techs to be able to diagnose bad data problems).
> >
> > The tables (on MSSQL) are populated via a bulk insert procedure that
> > converts nulls to zero length strings. I'm supposed to be creating a
> related
> > query that shows the frequency of certain columns containing data, and
> I'm
> > told that the non printable character isn't hurting anything else and
> won't
> > be fixed any time soon.
> >
> > Any help would be most appreciated.
> >
> > ~*~*~*~*~*~*~
> > Shay Bella Holmes
> > ~*~*~*~*~*~*~
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/