SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

create FUNCTION [dbo].fnSubstring_Index

(

@BaseString varchar(255),

@caracter varchar(255),

@pos tinyint

) RETURNS varchar(255)

AS

/* ****************************************************

Description:

EQuivalent a mysql substring_index---- ---- -----------

Created by Omar Rodriguez Tineo

**************************************************** */

BEGIN

/*

DECLARE @pos INT

Declare @BaseString varchar(255)

Declare @caracter varchar(255)

*/

Declare @indice...