Select Layer by Attribute in ArcPy

[MohammadrezaNikfal1]

I am working on a simple application. The user can choose either Numeric values or string values to select (i.e. valName). However if you write the where clause like this:

arcpy.SelectLayerByAttribute_management(lyr, "NEW_SELECTION", FieldName + opName + "'" + valName + "'")‍

It doesn't work for numbers and if you write like this:

arcpy.SelectLayerByAttribute_management(lyr, "NEW_SELECTION",FieldName + opName + valName)‍

  It doesn't work for strings. 

Any simple solution without if condition?

[RandyBurton]

"{} {} '{}'".format(FieldName,opName,valName) if type(valName) is str else "{} {} {}".format(FieldName,opName,valName)‍‍

You might try something like:

[MohammadrezaNikfal1 · Accepted solution]

This worked for me:

if type(valName) is str or type(valName) is unicode:
   whereClause = FieldName + opName + "'" + valName + "'"
else:
   whereClause = FieldName + opName + str(valName)
arcpy.SelectLayerByAttribute_management(lyr, "NEW_SELECTION", whereClause)‍‍‍‍‍

[RandyBurton]

You can also use "in"

if type(valName) in (str, unicode) else ...‍