select replace('ABC*DEFG********01','**','') from RDB$DATABASE
On Monday, December 7, 2015 12:26 PM, "Virna Constantin costel...@yahoo.com
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
#yiv7701085015 #yiv7701085015 -- #yiv7701085015
.yiv7701085015ygrp-photo-title{clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}#yiv7701085015
div.yiv7701085015ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px
solid black;height:62px;width:62px;}#yiv7701085015
div.yiv7701085015photo-title a, #yiv7701085015 div.yiv7701085015photo-title
a:active, #yiv7701085015 div.yiv7701085015photo-title a:hover, #yiv7701085015
div.yiv7701085015photo-title a:visited {text-decoration:none;}#yiv7701085015
div.yiv7701085015attach-table div.yiv7701085015attach-row
{clear:both;}#yiv7701085015 div.yiv7701085015attach-table
div.yiv7701085015attach-row div {float:left;}#yiv7701085015 p
{clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv7701085015
div.yiv7701085015ygrp-file {width:30px;}#yiv7701085015
div.yiv7701085015attach-table div.yiv7701085015attach-row div div a
{text-decoration:none;}#yiv7701085015 div.yiv7701085015attach-table
div.yiv7701085015attach-row div div span {font-weight:normal;}#yiv7701085015
div.yiv7701085015ygrp-file-title {font-weight:bold;}#yiv7701085015
#yiv7701085015
sorry, wrong response :(
On Monday, December 7, 2015 12:22 PM, "Virna Constantin costel...@yahoo.com
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
#yiv7701085015 --
.yiv7701085015ygrp-photo-title{clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}#yiv7701085015
div.yiv7701085015ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px
solid black;height:62px;width:62px;}#yiv7701085015
div.yiv7701085015photo-title a, #yiv7701085015 div.yiv7701085015photo-title
a:active, #yiv7701085015 div.yiv7701085015photo-title a:hover, #yiv7701085015
div.yiv7701085015photo-title a:visited {text-decoration:none;}#yiv7701085015
div.yiv7701085015attach-table div.yiv7701085015attach-row
{clear:both;}#yiv7701085015 div.yiv7701085015attach-table
div.yiv7701085015attach-row div {float:left;}#yiv7701085015 p
{clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv7701085015
div.yiv7701085015ygrp-file {width:30px;}#yiv7701085015
div.yiv7701085015attach-table div.yiv7701085015attach-row div div a
{text-decoration:none;}#yiv7701085015 div.yiv7701085015attach-table
div.yiv7701085015attach-row div div span {font-weight:normal;}#yiv7701085015
div.yiv7701085015ygrp-file-title {font-weight:bold;}#yiv7701085015
a quick answer :
m_char='**'
On Monday, December 7, 2015 12:12 PM, "'checkmail' check_m...@satron.de
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
But If the ID is ABC*DEFG, I get ABC*DEFG********01 and in this case only all *
from right should be deleted.
I have create this, is there a simpler way? #yiv7701085015 --
.yiv7701085015ygrp-photo-title{clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}#yiv7701085015
div.yiv7701085015ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px
solid black;height:62px;width:62px;}#yiv7701085015
div.yiv7701085015photo-title a, #yiv7701085015 div.yiv7701085015photo-title
a:active, #yiv7701085015 div.yiv7701085015photo-title a:hover, #yiv7701085015
div.yiv7701085015photo-title a:visited {text-decoration:none;}#yiv7701085015
div.yiv7701085015attach-table div.yiv7701085015attach-row
{clear:both;}#yiv7701085015 div.yiv7701085015attach-table
div.yiv7701085015attach-row div {float:left;}#yiv7701085015 p
{clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv7701085015
div.yiv7701085015ygrp-file {width:30px;}#yiv7701085015
div.yiv7701085015attach-table div.yiv7701085015attach-row div div a
{text-decoration:none;}#yiv7701085015 div.yiv7701085015attach-table
div.yiv7701085015attach-row div div span {font-weight:normal;}#yiv7701085015
div.yiv7701085015ygrp-file-title {font-weight:bold;}#yiv7701085015
#yiv7701085015 -- filtered {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2
4;}#yiv7701085015 filtered {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0
0;}#yiv7701085015 filtered {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0
0;}#yiv7701085015 filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2
4;}#yiv7701085015 filtered {panose-1:3 15 7 2 3 3 2 2 2 4;}#yiv7701085015
filtered {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;}#yiv7701085015
filtered {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv7701085015
p.yiv7701085015MsoNormal, #yiv7701085015 li.yiv7701085015MsoNormal,
#yiv7701085015 div.yiv7701085015MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv7701085015 a:link,
#yiv7701085015 span.yiv7701085015MsoHyperlink
{color:blue;text-decoration:underline;}#yiv7701085015 a:visited, #yiv7701085015
span.yiv7701085015MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv7701085015 p
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv7701085015 code
{}#yiv7701085015 pre
{margin:0cm;margin-bottom:.0001pt;font-size:10.0pt;}#yiv7701085015 tt
{}#yiv7701085015 span.yiv7701085015cat {}#yiv7701085015 span.yiv7701085015ct
{}#yiv7701085015 span.yiv7701085015HTMLVorformatiertZchn
{font-family:Consolas;}#yiv7701085015 p.yiv7701085015attach, #yiv7701085015
li.yiv7701085015attach, #yiv7701085015 div.yiv7701085015attach
{margin-right:0cm;margin-left:0cm;font-size:9.0pt;}#yiv7701085015
p.yiv7701085015bold, #yiv7701085015 li.yiv7701085015bold, #yiv7701085015
div.yiv7701085015bold
{margin-right:0cm;margin-left:0cm;font-size:10.0pt;font-weight:bold;}#yiv7701085015
p.yiv7701085015green, #yiv7701085015 li.yiv7701085015green, #yiv7701085015
div.yiv7701085015green
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;color:#628C2A;}#yiv7701085015
p.yiv7701085015replbq, #yiv7701085015 li.yiv7701085015replbq, #yiv7701085015
div.yiv7701085015replbq {margin:3.0pt;font-size:12.0pt;}#yiv7701085015
p.yiv7701085015ad, #yiv7701085015 li.yiv7701085015ad, #yiv7701085015
div.yiv7701085015ad
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv7701085015
p.yiv7701085015underline, #yiv7701085015 li.yiv7701085015underline,
#yiv7701085015 div.yiv7701085015underline
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv7701085015
span.yiv7701085015yshortcuts {}#yiv7701085015 p.yiv7701085015ad1,
#yiv7701085015 li.yiv7701085015ad1, #yiv7701085015 div.yiv7701085015ad1
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv7701085015
p.yiv7701085015ad2, #yiv7701085015 li.yiv7701085015ad2, #yiv7701085015
div.yiv7701085015ad2
{margin-right:0cm;margin-bottom:7.5pt;margin-left:0cm;font-size:12.0pt;}#yiv7701085015
p.yiv7701085015underline1, #yiv7701085015 li.yiv7701085015underline1,
#yiv7701085015 div.yiv7701085015underline1
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;text-decoration:underline;}#yiv7701085015
span.yiv7701085015yshortcuts1 {font-weight:bold;}#yiv7701085015
span.yiv7701085015yshortcuts2 {font-weight:normal;}#yiv7701085015
span.yiv7701085015E-MailFormatvorlage36
{color:#323E4F;font-weight:normal;font-style:normal;text-decoration:none
none;}#yiv7701085015 .yiv7701085015MsoChpDefault
{font-size:10.0pt;}#yiv7701085015 filtered {margin:70.85pt 70.85pt 2.0cm
70.85pt;}#yiv7701085015 div.yiv7701085015WordSection1 {}#yiv7701085015 filtered
{}#yiv7701085015 filtered {font-family:Symbol;}#yiv7701085015 filtered
{}#yiv7701085015 filtered {font-family:Wingdings;}#yiv7701085015 filtered
{font-family:Wingdings;}#yiv7701085015 filtered
{font-family:Wingdings;}#yiv7701085015 filtered
{font-family:Wingdings;}#yiv7701085015 filtered
{font-family:Wingdings;}#yiv7701085015 filtered
{font-family:Wingdings;}#yiv7701085015 filtered
{font-family:Wingdings;}#yiv7701085015 ol {margin-bottom:0cm;}#yiv7701085015 ul
{margin-bottom:0cm;}#yiv7701085015
