Oct 8, 2004 #1 olibh Programmer Mar 21, 2002 13 0 0 IE What is the SQL equivalent of the Mid function in a SQL Server view ? It will allow SELECT Left([que_file_key],2) But not Select Mid([que_file_key],3,20) It says Mid is not a recognised function name - anyone got any ideas ?
What is the SQL equivalent of the Mid function in a SQL Server view ? It will allow SELECT Left([que_file_key],2) But not Select Mid([que_file_key],3,20) It says Mid is not a recognised function name - anyone got any ideas ?
Oct 8, 2004 1 #2 andrea96 Programmer Jan 26, 2001 201 0 0 US You can use SUBSTRING. Upvote 0 Downvote