Re: Removing spaces in a field

From: Grace McCalman, Box 524, Trent University, Peterborough, <gmccalman_at_ivory.trentu.ca>
Date: 1996/05/11
Message-ID: <Dr9Bn3.88A_at_blaze.trentu.ca>#1/1

In article <tony.831722073_at_jugula>, tony_at_bilpin.co.uk (Tony Desborough) writes:
>
>Hi,
>
>How do I use SQL to remove all spaces from a field ?
>e.g update 'EX 300' to 'EX300'
>
>Please reply via email.
>Thanks in advance
>Tony
use translate (found in sql language manual) e.g. select translate(<field_name,' ','') from ... Received on Sat May 11 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: Grace McCalman, Box 524, Trent University, Peterborough,: "Re: Removing spaces in a field"
Previous message: Chris: "Re: Access 95 ODBC to Oracle 7.2?"
In reply to: Tony Desborough: "Removing spaces in a field"
In reply to Tony Desborough: "Removing spaces in a field"
Next in thread: Grace McCalman, Box 524, Trent University, Peterborough,: "Re: Removing spaces in a field"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message