teradata sql substring

"-" occurrence CHARINDEX ('-', reverse (@str)) Gets the character after the last "-" Reverse (substring (reverse (@str), 1,charindex ('-', reverse (@str))-1)) Type conversions CAST (@XX as char (20)) CONVERT (char), @XX) Cast (0 as bit) --Simple Case function Case Sex When ' 1 ' Then ' men ' When ' 2 ' then ' women ' Else ' other ' end --case search function case If sex = ' 1 ' Then ' man ' When sex = ' 2 ' Then ' women ' Else ' other ' end decla

Label:bcdencodingimacodease sysgetchromeset #encodeing =utf-8 Import Requests Import sys reload (SYS) sys.setdefaultencoding (' utf-8 ') payloads = list (' [Email protect Ed]_. ') headers = {' Cache-control ': ' max-age=0 ', ' Accept ': ' text/html,application/xhtml+xml,application/xml;q=0.9,image/ webp,*/*;q=0.8 ', ' upgrade-insecure-requests ': ' 1 ', ' user-agent ': ' mozilla/5.0 (Windows NT 6.1; WOW64) applewebkit/537.36 (khtml, like Gecko) chrome/45.0.2454.101 safari/537.36 ', ' accept-