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 some
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 creteria
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
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
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 interested
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.. I tried a
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 (code, 'k'
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 the same