Advanced Search

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 dept is required, the following 3 results were found.

  1. Stop Excel Row Height Self-Adjust on Refreshhttps://joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

    the smallest data value (one that I know will never be two lines (or two words)) within the SQL query itself. We have a DEPT column that is an acronym of the departments so for example: SELECT Date, Reservation, Contact, JobTitle, Dept FROM...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  2. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

    and I add the following parameters: p_RequestID specified as "ID (Leave)"... this is the ID of the Leave form record. p_Dept as the name of the "Department"... this is found on the Employee form not the leave form. p_LeaveFrom this is the value of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. Convert to Proper Case in T-SQLhttps://joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

    Smith-Jones HEAD OF IT SERVICES Head of IT Services FLAT 123A Flat 123A MRS. O'CONNOR-MCDONALD Mrs. O'Connor-McDonald ORG_DEPT_STATUS Org_Dept_Status SEND.HELP.NOW Send.Help.Now PO BOX 1234 PO Box 1234 B'MTH BH1 3AB B'mth Bh1 3Ab 123 THE WORLD'S END 123...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
Results 1 - 3 of 3

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

Please publish modules in offcanvas position.