Tip of the Month - April, 2001

Performing an AdHoc Search for Records 
with a Carriage Return in a Field

To perform an AdHoc search on a specific field for values containing a Carraige (Hard) Return, follow this example:
We want to find a list of records that have carriage returns in the company field.

1. Create a new AdHoc Search and name it.

2. Select Calculation for its mode.

3. Enter this formula into the Comparison Value field:
charindex(char(13),Name.COMPANY) 0

Note:
Through SQL, you can use this query:
select * from Name where charindex(char(13),Name.COMPANY) 0