Click here to Skip to main content
15,921,548 members
Home / Discussions / Database
   

Database

 
QuestionMANIPULATING VIEWS Pin
Wisdom200417-Sep-05 3:53
Wisdom200417-Sep-05 3:53 
QuestionLike Query & Null Values Pin
rich_wenger16-Sep-05 12:08
rich_wenger16-Sep-05 12:08 
AnswerRe: Like Query & Null Values Pin
turbochimp16-Sep-05 17:39
turbochimp16-Sep-05 17:39 
GeneralRe: Like Query & Null Values Pin
rich_wenger17-Sep-05 1:18
rich_wenger17-Sep-05 1:18 
GeneralRe: Like Query & Null Values Pin
rich_wenger17-Sep-05 3:21
rich_wenger17-Sep-05 3:21 
GeneralRe: Like Query & Null Values Pin
turbochimp17-Sep-05 5:56
turbochimp17-Sep-05 5:56 
GeneralRe: Like Query & Null Values Pin
turbochimp17-Sep-05 5:36
turbochimp17-Sep-05 5:36 
GeneralRe: Like Query & Null Values Pin
rich_wenger18-Sep-05 14:49
rich_wenger18-Sep-05 14:49 
Sorry, just got back in town; here is the stored procedure. Looks like you're right, it doesn't pull if I query both a First and Last name.

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO




CREATE PROCEDURE ia.SP_StaffPhysicianSelectCommand
(
@Param2 varchar(35)
)
AS
SET NOCOUNT ON;

SELECT docIndex, docLName, docFName, docMName FROM dbo.tblStaffPhysicians
WHERE (docFName + ' ' + ISNULL (docMName, '') + ' ' + docLName LIKE '%' + @Param2 + '%')
ORDER BY docLName, docFName




GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO


-- modified at 20:49 Sunday 18th September, 2005
GeneralRe: Like Query & Null Values Pin
turbochimp18-Sep-05 18:06
turbochimp18-Sep-05 18:06 
AnswerRe: Like Query & Null Values Pin
Mike Dimmick17-Sep-05 10:43
Mike Dimmick17-Sep-05 10:43 
GeneralRe: Like Query & Null Values Pin
rich_wenger18-Sep-05 14:53
rich_wenger18-Sep-05 14:53 
Questionuse mySQL with c# applications Pin
Sasuko16-Sep-05 0:55
Sasuko16-Sep-05 0:55 
AnswerRe: use mySQL with c# applications Pin
enjoycrack16-Sep-05 1:32
enjoycrack16-Sep-05 1:32 
GeneralRe: use mySQL with c# applications Pin
Sasuko16-Sep-05 4:05
Sasuko16-Sep-05 4:05 
AnswerRe: use mySQL with c# applications Pin
André Ziegler17-Sep-05 11:55
André Ziegler17-Sep-05 11:55 
GeneralRe: use mySQL with c# applications Pin
Sasuko17-Sep-05 23:20
Sasuko17-Sep-05 23:20 
GeneralRe: use mySQL with c# applications Pin
André Ziegler18-Sep-05 1:14
André Ziegler18-Sep-05 1:14 
QuestionConsolidation of database Pin
utsav_verma15-Sep-05 23:07
utsav_verma15-Sep-05 23:07 
AnswerRe: Consolidation of database Pin
Hesham Amin16-Sep-05 2:49
Hesham Amin16-Sep-05 2:49 
QuestionMSDE not connecting in windows 98 Pin
Nilesh Gambhava15-Sep-05 21:28
Nilesh Gambhava15-Sep-05 21:28 
QuestionMSDE client tools Pin
Ahsan Askare15-Sep-05 18:48
Ahsan Askare15-Sep-05 18:48 
AnswerRe: MSDE client tools Pin
enjoycrack15-Sep-05 22:46
enjoycrack15-Sep-05 22:46 
AnswerRe: MSDE client tools Pin
Michael P Butler16-Sep-05 1:54
Michael P Butler16-Sep-05 1:54 
QuestionFastest way to copy table in SQLServer 2000 Pin
mikker_12315-Sep-05 15:46
mikker_12315-Sep-05 15:46 
AnswerRe: Fastest way to copy table in SQLServer 2000 Pin
Alomgir Miah15-Sep-05 17:24
Alomgir Miah15-Sep-05 17:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.