SELECT * WHERE REPLACE(UsersField,'-') = 'MyValue'
On Friday, February 12, 2016 3:57 AM, "[email protected]
[firebird-support]" <[email protected]> wrote:
<!--#yiv0321102219 #yiv0321102219
.yiv0321102219ygrp-photo-title{clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}#yiv0321102219
div.yiv0321102219ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px
solid black;height:62px;width:62px;}#yiv0321102219
div.yiv0321102219photo-title a, #yiv0321102219 div.yiv0321102219photo-title
a:active, #yiv0321102219 div.yiv0321102219photo-title a:hover, #yiv0321102219
div.yiv0321102219photo-title a:visited {text-decoration:none;}#yiv0321102219
div.yiv0321102219attach-table div.yiv0321102219attach-row
{clear:both;}#yiv0321102219 div.yiv0321102219attach-table
div.yiv0321102219attach-row div {float:left;}#yiv0321102219 p
{clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv0321102219
div.yiv0321102219ygrp-file {width:30px;}#yiv0321102219
div.yiv0321102219attach-table div.yiv0321102219attach-row div div a
{text-decoration:none;}#yiv0321102219 div.yiv0321102219attach-table
div.yiv0321102219attach-row div div span {font-weight:normal;}#yiv0321102219
div.yiv0321102219ygrp-file-title {font-weight:bold;}#yiv0321102219 -->
<!--#yiv0321102219 #yiv0321102219ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0321102219
#yiv0321102219ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0321102219
#yiv0321102219ygrp-mkp #yiv0321102219hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0321102219 #yiv0321102219ygrp-mkp #yiv0321102219ads
{margin-bottom:10px;}#yiv0321102219 #yiv0321102219ygrp-mkp .yiv0321102219ad
{padding:0 0;}#yiv0321102219 #yiv0321102219ygrp-mkp .yiv0321102219ad p
{margin:0;}#yiv0321102219 #yiv0321102219ygrp-mkp .yiv0321102219ad a
{color:#0000ff;text-decoration:none;}-->
Users can enter values with dashes (-) in random locations. I don't know where
they might put them. I need to select a record using a where clause that
doesn't have those dashes. For example, the user might record an insurance
policy number as 12-345678-01 or 123-456-789-01. All I will know are the
number, and not where they put the dashes. Is there a way to suppress the
dashes in the Select Clause, or the Where Clause? This is being done in a
Delphi 2007 program using IBDAC.
It would be nice if I could do something like ... SELECT * WHERE
HIDE('-',UsersField) = 'MyValue'Or the equivalent in the Select statement.
