Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- AND
- (
- (up.name LIKE ('%' + @search_fullname + '%') COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI) OR
- (up.surname_1 LIKE ('%' + @search_fullname + '%') COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI) OR
- (up.surname_2 LIKE ('%' + @search_fullname + '%') COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI) OR
- (RTRIM
- (
- { fn IFNULL(RTRIM(up.name), '') } + ' ' + { fn IFNULL(RTRIM(up.surname_1), '') } + ' ' + { fn IFNULL(RTRIM(up.surname_2), '') }
- ) LIKE ('%' + @search_fullname + '%') COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI)
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement