I want to sql script input string and value in database is number?

Question

I want to sql script in select

input string and value in database is number?

EX.

Input: Wait Approve

ApproveStatus(nvarchar)
"0"
"2"  
"4"...

ApproveStatus = 2 It's "Wait Approve"

I want sql script find value "Wait Approve" in ApproveStatus and Output is fields ApproveStatus = 2

This first in questions

cant understand what you are asking here " input string value in database is number" — isuruAb, Feb 09 '17 at 06:30
i think you should add a new column like description,,,then you can select id from it — Salmaan C, Feb 09 '17 at 06:31

score 0 · Answer 1 · answered Feb 09 '17 at 10:09

Something like this?

Given the following data:

CREATE TABLE statuslookup (
    id int unique,
    label nvarchar unique
);
INSERT INTO statuslookup (id, label) values (2, 'Wait Approve');

Then if you need to convert from label to id:

SELECT id FROM statuslookup WHERE label = 'Wait Approve';

Hopefully that at least gets you started.....

1 Answers1