Search results for query: *

ok thank you!

i want to increase the sizes of these 2 fields how do i do that? CON_FNAME,CON_LNAME

ok so what i need to do is take that one with 11 and take it down to 9 by removing dashes is that possible? or would it be easier to just take the one thats 9 and make it 11? if thats the case how do i resize the vield to 11?

it looks like ss# is the issue one is 11 one is 9

7 2 30 30 22 2 10 35 12 17 11 thats corecraccustomername

7 2 30 30 22 2 10 30 9 thats what i get from that one...

Same error here is my code did i do it wrong? ALTER PROCEDURE sp_CoreTrack1 AS SET NOCOUNT ON INSERT CoreTracCustomerName ( REC, CCODE, ATTN, STREET, CITY, STATE, ZIP, FULL_NAME, CON_FNAME, CON_LNAME, SS ) SELECT DISTINCT Max(DataLength(ct.CUSTNUM))...

how does the max data length thing work?

how do i find out which one it is.. they should all be the same length in both tables... also is the substring a way to fix this? it has been suggested but i have no idea what that means...

This query... ALTER PROCEDURE sp_CoreTrack1 AS SET NOCOUNT ON INSERT CoreTracCustomerName ( REC, CCODE, ATTN, STREET, CITY, STATE, ZIP, FULL_NAME, CON_FNAME...

This query... ALTER PROCEDURE sp_CoreTrack1 AS SET NOCOUNT ON INSERT CoreTracCustomerName ( REC, CCODE, ATTN, STREET, CITY, STATE, ZIP, FULL_NAME, CON_FNAME, CON_LNAME, SS# ) SELECT DISTINCT ct.CUSTNUM, ct.TYPEGROUP, ct.ATTN, ct.STREET, ct.CITY...