Encerrado

How to search using ms sql query for a particular parameter and look up each character of the inpt string

Job Description:

Input String - SS-10106

Query result would as per the query

select itemcode, U_MfrPartNo from OITM where U_MfrPartNo like '%S%S%1%0%1%0%6%'

How do I split the string into characters to use in the like part of the query

Habilidades: SQL, MySQL

Sobre o Cliente:
( 6 comentários ) Alpine, United States

ID do Projeto: #35371305

24 freelancers estão ofertando em média $37 nesse trabalho

rajveerdeveloper

Dear Client, Greetings!! I am glad to submit a proposal for your Project. I have been engaged with Web Development and Web Designing. I have gone through your requirements and I would like to work on your project. Mais

$30 USD in 7 dias
(40 Comentários)
6.8
nixtech

Hello Sir I can write split character query to search for it. I am willing to start right away. Please check my profile for work and experience. Regards Hardeep

$50 USD em 1 dia
(150 Comentários)
6.5
kreativesystem91

Hello, a pleasure to greet you, my name is Alex, I would be interested in working on your project, I have immediate availability I remain attentive to your comments Greetings

$10 USD em 1 dia
(136 Comentários)
6.1
BitLabs

Dear sir, I will complete your project today, LIFETIME error free guarantee and provide 365 days (ONE YEAR) support... I have right SQL MySQL to execute your esteemed project.

$20 USD in 7 dias
(45 Comentários)
6.0
tljafar

Dear Sir, I read your project description. I am ready to start working quickly on your project. Send message on freelancer to discuss this work ... I am an experienced web developer and I can work with your nee Mais

$20 USD em 1 dia
(20 Comentários)
4.8
MimiFL

Hi, would you mind attaching few more "input strings" and how the data in " U_MfrPartNo" column looks like? I believe i can help you and i am available right now. Feel free to message me if you are interested. Thanks, Mais

$15 USD em 1 dia
(29 Comentários)
4.3
bizmanas

Hi I have 15 years of experience in SQL server Database development, MySQL development, postgress development, power bi. Programming using python and C#.Expertise in data analytics. Machine learning using python. I pro Mais

$180 USD in 2 dias
(10 Comentários)
4.1
castillajoselui3

Hello I have checked your project description carefully As a senior web developer, I have strong experienced about MYSQL query. So i am pretty sure i will deliver the best result within 3 hours. Please contact me via c Mais

$30 USD em 1 dia
(10 Comentários)
3.6
merinsinha

I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom Mais

$30 USD em 1 dia
(29 Comentários)
4.0
tsmcguinness

hello. i am php, mysql expert having rich experience for 6+ years. please contact me. i will provide the best solution what you want. thanks.

$30 USD in 7 dias
(1 Comentário)
2.3
tyleleerking

How's it going? No problem. I checked your detail seriously and got confident that give you wonderful result. I can start your work right now. Tyler

$20 USD em 1 dia
(1 Comentário)
2.0
kurbsky

Do you need something like this: create function AlpineSplit(Str varchar(100)) returns varchar(201) deterministic begin declare Cnt int default 1; declare Len int default char_length(Str); declare Res varchar(20 Mais

$10 USD em 1 dia
(5 Comentários)
1.6
brankodev22

Hi, it's FREE for your requirement. Pls contact me for more detail, I am not clear yet Thanks. Regard

$20 USD in 7 dias
(1 Comentário)
1.0
matthallmik

Hi client! Thanks for your job posting. I have already checked your project requirement carefully and I am ready to start your project now. Hope to discuss more detail for your project via good chatting and your kind Mais

$30 USD em 1 dia
(0 Comentários)
0.0
dominicdelacruz1

Hello. I am an experienced full-stack developer with over 5+ years of extensive industry experience in developing and handling projects on web. I am currently working on latest tools & technologies like JavaScript, PHP Mais

$20 USD em 1 dia
(0 Comentários)
0.0
davisclaimer

Hello! client! I have seen your description and understand about your problem. I'm Mysql expert and I can help you in short time. It's easy technical problem. As you can see, I'm top website developer and especially I' Mais

$20 USD em 1 dia
(1 Comentário)
0.0
haroon741

Hi there! I have vast experience in writing SQL queries for various database and will be able to sort this out very quickly. I am new to this site and eager to deliver high quality solution fast to build my five start Mais

$15 USD em 1 dia
(0 Comentários)
0.0
Jovana62

⭐⭐ Hello ⭐⭐ I have checked your project description carefully and I think that I can help you to complete this project 100% perfectly sure to satisfy your requirement. I have more than 7 years of experience i Mais

$20 USD em 1 dia
(0 Comentários)
0.0
theSQL

Hello, I've already completed a SQL solution to your project. I'm available immediately to deliver it, and make sure your team understands how to use it. Feel free to message me. Regards, Adam Burch

$15 USD em 1 dia
(0 Comentários)
0.0
sjmkumar

Hi Sir , I have 10 + years experience in Asp. Net C# & Sql Server. I have good knowledge in store procedure, trigger, CTE, Views, Index based performance, functions. performance based queries. I am very much interes Mais

$30 USD em 1 dia
(0 Comentários)
0.0