Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming collation is required, the following 5 results were found.

  1. Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

    End-users were complaining that some default values get listed twice because their system was case-sensitive despite the collation of the SQL Server being case-insensitive. What? End-users said that they could see the options "Data Not Yet Available" as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB

  2. Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

    to: PHP 5.4 MySQL 5.1.4 Databases initially setup with collation 'latin1_swedish_ci' What Another article trying to help people display foreign characters on their website without the funny question marks in diamond symbols and how I solved it in my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB

  3. T-SQL example of Case-Sensitive Soundexhttps://www.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

    the case is different, eg. "Data not yet available". The final system (qlikview) was case-sensitive despite our server collation being case-insensitive. Furthermore, we now have the task of finding all the variations of the default values which we found...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  4. Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

    Yes you could just run a SELECT DISTINCT query along with collation to make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the columns. How? IF...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *

  5. Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

    does not match the following string: cdefg You can use the collating sequence operator in any regular expression where collation is needed. For example, to specify the range from 'a' to 'ch', you can use the following expression: [a-[.ch.]] POSIX...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
Results 1 - 5 of 5

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Joes Word Cloud

Please publish modules in offcanvas position.