How to write this sql query

select * from companies where name like 'A%'

Hello sir,

Will this query return company starting from any alphabet i enter whether in small or big case alphabets?

The query returns values only if capital letters are entered. If i use small letters also it should return values

ALTER PROCEDURE [dbo].[Usp_LoadData] @FieldName varchar(MAX), @FieldID varchar(MAX) AS

IF(@FieldName='SearchCompany' AND @FieldID<>'') BEGIN SELECT * FROM tbl_CompanyMaster WHERE CompanyName LIKE @FieldID+'%' OR CompanyCode LIKE '%'+@FieldID+'%' OR Category LIKE '%'+@FieldID+'%' END

Try running the query on your database. If it does not post your query here I'll modify it

Also use Code Block to add codes

USE [WEB-ERMS]
GO
/****** Object:  StoredProcedure [dbo].[Usp_SearchQuery]    Script Date: 12/30/2011 11:18:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Usp_SearchQuery]
@FieldName varchar(MAX),
@FieldID varchar(MAX)
AS
IF(@FieldName='Company Name' AND @FieldID<>'')
BEGIN
SELECT * FROM tbl_CompanyMaster WHERE CompanyName LIKE @FieldID+'%' 
END
IF(@FieldName='Company Code' AND @FieldID<>'')
BEGIN
SELECT * FROM tbl_CompanyMaster WHERE CompanyCode LIKE @FieldID+'%' 
END
IF(@FieldName='Category' AND @FieldID<>'')
BEGIN
SELECT * FROM tbl_CompanyMaster WHERE Category LIKE @FieldID+'%' 
END