<div>
if you just want to know if one string contains another you can use &quot;if (str1 CONTAINS(str2)) then&quot; in a stored procedure<br />
<br />

</div>


if you just want to know if one string contains another you can use "if (str1 CONTAINS(str2)) then" in a stored procedure



<div>
I will use the AdHoc UDF library - thanks much
</div>


I will use the AdHoc UDF library - thanks much

<div>
<div class="content wysiwyg-content">
Firebird apparently does not have a function to find one string inside another. How do I implement this? I have the Free_UDF library (FBUDF.dll) loaded into Firebird.<br />
<br />
Example: How would you implement this type of SQL statement:<br />
select email, pos('@',email) PE from table
</div>
</div>


Firebird apparently does not have a function to find one string inside another. How do I implement this? I have the Free_UDF library (FBUDF.dll) loaded into Firebird.

Example: How would you implement this type of SQL statement:
select email, pos('@',email) PE from table

String Position Function

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.