Fw: MI-L update field in table with just a space

[Rick Luangkhot]

Sorry, instead of $Char(32), I meant Chr$(32).
----- Forwarded by Rick Luangkhot/HOU/US/IHSE on 09/15/2003 12:24 PM -----
                                                                           
             Rick                                                          
             Luangkhot/HOU/US/                                             
             IHSE                                                       To 
                                       "Brandi McGunigal"                  
             09/15/2003 12:24          <[EMAIL PROTECTED]>                  
             PM                                                         cc 
                                       "MapInfo List"                      
                                       <[EMAIL PROTECTED]> 
                                                                   Subject 
                                       Re: MI-L update field in table with 
                                       just a space(Document link: Rick    
                                       Luangkhot)                          
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           



Hello Brandi,

Try update my table set fieldname = $Char(32).  I'm  correct, 32 is the
ASCII code for a space.

I hope this helps.

Best regards,

Rick


                                                                           
             "Brandi                                                       
             McGunigal"                                                    
             <[EMAIL PROTECTED]                                          To 
             >                         "MapInfo List"                      
                                       <[EMAIL PROTECTED]> 
             09/15/2003 12:09                                           cc 
             PM                                                            
                                                                   Subject 
                                       MI-L update field in table with     
                                       just a space                        
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           




Hello List,

Is there a way to update a character field to have only a single space in
it?

I tried the following command:
update mytable set fieldname = " "

However, this didn't take.
Is this even possible?

Thanks in advance,

Brandi


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.516 / Virus Database: 313 - Release Date: 9/1/2003


---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 8393




---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 8395