[#IDEA-18948] SQL: redlines parameter in lower()

IDEA: Feedback

SQL: redlines parameter in lower()

Created: 01 Aug 08 18:21 Updated: 01 Aug 08 18:24

Component/s:

SQL

Build:

8,637

Description

« Hide

SELECT a.owner_id FROM user_profile a, owner b where a.user_type=? And a.owner_id is not null and a.owner_id = b.owner_id and instr( lower(b.name), lower

) != 0

All

Comments

Work Log

Change History

Sort Order:

[ Permlink | « Hide ]

Jon Steelman - 01 Aug 08 18:24

SELECT a.owner_id 
FROM user_profile a, owner b where a.user_type=? And a.owner_id is not null and a.owner_id = b.owner_id and instr( lower(b.name), lower(?) ) != 0