Re: varchar problem

Andy Hassall wrote:
[snip]

 If the spaces are there it's because they were in the original data when
inserting them.


You are correct - the apparent randomness of the leading white space was throwing me off. <blush>I had not deleted the old input as I thought.</blush>

Thanks Andy (and Geoff) - sometimes the only way I work a thing out is by posting and looking the fool (again).


--
TK
http://www.wejuggle2.com/
Still Having a Ball







..

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
.

Relevant Pages

  • Re: varchar problem
    ... inserting them. ... Thanks Andy (and Geoff) - sometimes the only way I work a thing out is ...
    (alt.php)
  • Re: Transforming ascii file (pseduo database) into proper database
    ... contained therein so that it can be inserted into an existing database. ... So I iterate over the file maintaining a list of calls for the given phonenumber, and when the phonenumber changes, I deal with the previous cache of data, then re-initialize with the new phone's data. ... create a temp DB, skim through the file inserting all your data into a table in this DB, then use DB functionality on it ...
    (comp.lang.python)
  • Re: Conditional Column Name On Insert
    ... this would be a solution....but the table in which I'm inserting ... I had used ellipsis as a placeholder for the value to delete. ... CURRENT_TIMESTAMP in the first column (OTFechaBorrador) and NULL in the ...
    (comp.databases.ms-sqlserver)
  • Re: January round up
    ... andy put down his happy meal and blurted: ... "Receive to it the right in top you, kissing you the stupid hun and kiss ...
    (uk.sport.football.clubs.rangers)
  • Re: Why relativists dont understand Einsteins 1905 mathematics.
    ... Did you snip something? ...  I seem to be missing whatever ... In replying to an earlier message from Andy, ... I am very happy to APOLOGIZE to ...
    (sci.physics.relativity)