To search stored procedures using MS-SQL you can use the snippet below.
Sample MSSQL
SELECT Name FROM sys.procedures WHERE name LIKE '%StoredProcName%'
To search stored procedures using MS-SQL you can use the snippet below.
SELECT Name FROM sys.procedures WHERE name LIKE '%StoredProcName%'
To use String.Contains in Python you can use the IN operator.
testString = "Hello World 2015"
if "World" not in testString:
print("World is not in String")
else:
print("World is in String")