i have changed the BMS_Id datatype integer to VarChar in my code having BMS_id as integer how can i change to VARCHAR IN my Code how can modify this code Which can accept BMS_id as VarChar also

Please Login or Register  to view this content.
example:

BMS_ID level(1/2/3) item num Original Mfg Name Original Mfg Part #
BMS10001 level 1 1071051 fgbhdfgdfgdsf 54469-03
BMS10002 level 3 1034059 NUMATICdgsS 139330P