Case Insensitive Searching with AS/400 SQL - Support

Case Insensitive Searching with AS/400 SQL

From Support

Jump to: navigation, search

set option srtseq = *LANGIDSHR

This way a where name = 'charles wilt'

will find: 'Charles Wilt' 'charles wilt' 'CHARLES WILT'

Retrieved from "http://wiki.rjssoftware.com/wiki/index.php/Case_Insensitive_Searching_with_AS/400_SQL"

Categories: RJS Imaging Scan Workstation | TBPR | Knowledge Base | How To

Views

Personal tools

Log in / create account

Search

Toolbox