Re: SQL Insert - Removing Blanks Between Pipes

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Hi Robert

I imagine if he uses the strip(field) or trim(field) function, it'll end 
up being an empty string - no problem with that.

I don't know the exact syntax by memory, gotta check the manuals.

Vern, in balmy central Minnesota

On 12/9/2010 6:28 PM, Robert Munday wrote:
>     Greetings from sunny Florida.
>
>     A staff programmer is writing to a pipe-delimited file using an SQL
>     Insert.  He wants to remove blanks from a blank field should one occur:
>
>     Instead of   | field of blanks |
>
>     he wants || .
>
>     How could this be done?
>
>     Robert Munday
>     Munday Software Consultants
>     Montgomery, AL
>     on assignment in Jacksonville, Florida