Hello,
I would like to select every row which has got in the column CODE a "k"
but I want to exclude every "kV" -- may be it is due to the fact that
it is Saturday and I work too long I don't get it.. I tried a
subselect, union but I struggle with the two select creteria on one
column.
Can s
Michael Hoeller wrote:
Hello,
I would like to select every row which has got in the column CODE a "k"
but I want to exclude every "kV" -- may be it is due to the fact that
it is Saturday and I work too long I don't get it.. I tried a
subselect, union but I struggle with the two select creteri
Hello,
sometime you have to write a mail and your brain gets cleared...
select a.code
from stamm a
where
a.skart in (
(select skart
from stamm
where code like '%k%')
)
and a.code not like '%V%';
May be this is not nice but this brings back the list I have.
Hello
I like to delete "k" from a string with the statement
update stamm set code = replace (code, 'k' , '');
But the only way to get the canditates I want to update is the following
statement. It seems that I can not update when I do a join.
Is there a way around it? With google I found a h
Hello all,
thanks for the answere to the prev. thread. With the help of them
I solved the problme I used "not like" instead of <> and this leads
to a problem. This works for me:
update stamm
set code = replace (code, 'k' , '')
where code like '%k%' and code <> '%V%';
I would still be intere
On Sat, Sep 10, 2005 at 17:45:50 +0200,
Michael Hoeller <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I would like to select every row which has got in the column CODE a "k"
> but I want to exclude every "kV" -- may be it is due to the fact that
> it is Saturday and I work too long I don't get it..
On Sat, Sep 10, 2005 at 18:56:10 +0200,
[EMAIL PROTECTED] wrote:
> Hello all,
>
> thanks for the answere to the prev. thread. With the help of them
> I solved the problme I used "not like" instead of <> and this leads
> to a problem. This works for me:
>
> update stamm
> set code = replace
Marc G. Fournier wrote:
> Are there any data types that can hold pretty much any type of
> character? UTF-16 isn't supported (or its missing from teh docs), and
> UTF-8 doesn't appear to have a big enough range ...
UTF-8 has exactly the same "range" as UTF-16. In any case, the UTF-8
encoding in
On Saturday 2005-09-10 11:43, Peter Eisentraut wrote:
> Marc G. Fournier wrote:
> > Are there any data types that can hold pretty much any type of
> > character? UTF-16 isn't supported (or its missing from teh docs), and
> > UTF-8 doesn't appear to have a big enough range ...
>
> UTF-8 has exactly
