Thank you this work when the user enter the full number but the idea to wildcards is that they can type

@number1 + 56_4__

@number2 = 6__7__

Hello

I am looking to solve the same issue in my case the user sometimes wants to search for one number or sometimes pull a report for two numbers

So I tried ...

• This reply was modified 4 years, 2 months ago by  Ysa.

Hello

Yes, the user may enter two numbers and you want to search for both of them or might enter just one number

How I can search two different numbers using wildcards.

I need to search for phone number user should be able to enter any number and bring the information which work with...

• This reply was modified 4 years, 2 months ago by  Ysa.

Thank you,  it works!

Hi

Is not working I have a big data

Sorry everybody I was trying to edit my post but I cant

CREATE TABLE Budget (     budget_type varchar (1),    account_id (4) varchar     a_gl1 varchar (6),     a_gl2 varchar(6),    employee_number varchar(10),...

To Create table:

CREATE TABLE Budget (

budget_type varchar (1),

Account_id (4) varchar

a_gl1 varchar (6),

a_gl2 varchar(6),

employee_number varchar(10),

p_empl_proj_num varchar (6),

budget_req_amt1 int,

percent int,

Effective_date (datetime),

Description (50),

hI pHIL

Insert into Budget (

budget_type, account_id,

a_gl1, a_gl2,employee_number,

budget_req_amt1, percent,

Effective_date, emp_proj_num,

a_projection_no, Description)

values (‘P’, ‘6252,’ ‘010470’, ‘513120’, ‘100015’, ‘150000’, ‘50’, ‘10/1/2019’, ‘2020,’’ 0,’ ‘NULL’

‘P’, ‘6252’,  ‘010470’, ‘514120’, ‘100015’, ‘150000’, ‘50’, ‘10/1/2019’, ‘2020’, ‘0’,’NULL’

‘P’,...

because now  when I use the actual max in the where clause is not working I received the error "invalid column name"

where Actual_max_pay > emp_salary

Hi bmg002

Yes, it work thank you, I need to practice more function and store procedures as well.

Hi

I am attaching the file with information. Thank you!

I got duplicates, so I was trying to create CTE's

Thank you but it didnt work !