Source Code



Procedure For Search Name

  • anonymous
  • Nov 04' 13
  • SQL
  • 394
  • 52
  • United States

If you are a developer warehouse application, and user want to search customer name by first character of customer name, use this procedure to simplify your job:

 

create procedure search
@kunci as varchar(50)
as
select * from MS_Customer where left(customername,LEN(@kunci))[email protected]

 

For use the procedure:

 

search 'BI'

all customer name with first charakter BI like Bily, Bios, Biarn, Bird will be shown in the table view, happy coding

  • Tags :
comments powered by Disqus

Related Code

Encrypt and Decrypt

SQL Server 2000 installation fails with "...previous program installation..." error message

Default Time Zone

Form Validation Function

Spell Text and Hear It

Create Symphony With Midi Sound

Get IP Address

Splash Screen

Border Radius

Session for Keep Values



Category