Results 1 to 6 of 6

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Android C3P0 finalista's Avatar
    Join Date: Jul:2009
    Location:
    Posts: 948

    varchar(), Firebird

    Firebird , , :
    --
    :
    ----
    - .
    SQL , , , varchar() ?

  2. #2
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    -
    Code:
    update tablename set myfield=replace(myfield,'  ',' ')
    . , 2 , -.
    Last edited by tedych; 17th December 2012 at 00:19.

  3. #3
    Android C3P0 finalista's Avatar
    Join Date: Jul:2009
    Location:
    Posts: 948
    Quote Originally Posted by tedych View Post
    -
    Code:
    update tablename set myfield=replace(myfield,'  ',' ')
    . , 2 , -.
    !!!
    , , , 3 ..
    , , ..
    .

  4. #4
    Registered User hateras's Avatar
    Join Date: Jan:2011
    Location: Kronos III
    Posts: 1,028
    tedych - / 3 , 4 , /
    2 , - , , .

    SELECT * from TABLENAME where myfield LIKE '%--%'
    ASRock B550M Pro 4; Ryzen R5 3600; 2x16 GiB G.SKILL Aegis 3200; 1TB Samsung QVO 960 + 3TB Seagate IronWolf; Zalman Z1

  5. #5
    Android C3P0 finalista's Avatar
    Join Date: Jul:2009
    Location:
    Posts: 948
    :
    Code:
    select * from TABLE_NAME where FIELD_NAME like '%  %'
    3 , :
    Code:
    update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, '  ', ' ')
    , o.k.
    , :
    Code:
    while ((select count(ID) from TABLE_NAME where FIELD_NAME like '%  %') > 0) do
      UPDATE TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, '  ', ' ')

  6. #6
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    , (php, perl ..) .
    , . 3-4-5 , hateras .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |