Re: SQL question

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

There's a function called POSSTR or STRPOS - check the SQL Reference. 
It returns the position of the first occurrence of a search string 
after a start position. You could nest a couple of these - do the 
first for a blank. Then check the remainder using a substring 
operation to see whether it is all blanks (test for ' ' is adequate). 
This can be in the WHERE clause of an UPDATE. The UPDATE uses the 
same substring in the SET.

At 07:35 AM 2/6/2006, you wrote:

> HI I have to remidiate a bunch of files. Some programs are not
> initializing properly so that some records, have a character at the end,
> that should not be there ( belongs to a prev.)
>
> I need to write a small prg that will look for a blank, then look for
> something other than a blank, and replace w/ a blank. Can this be done
> easily in SQL ?
>
> Thanks,
> Steve
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.